I am creating some excel sheets for work and need to password protect them all. However I know there will be some people that will attempt to hack the file.
Is there a way that I can open the spreadsheet and see if someone has turned ever off the protection.....(I am assuming that they turned...
I have a similar question to this topic. When I go to adjust column widths, or add a column, I get the following error message "cannot shift objects off sheet". All of my protections are turn off. Is there another protection setting somewhere that someone placed on this sheet, or is this a...
I have two similar workbooks, 'A' and 'B'. The summary sheet in 'A' has formulas that reference back to the data sheet in 'A'. When I copy the summary sheet from 'A', into 'B', I would like the formulas to remain the same, but so they reference to the data sheet in 'B' insteadof 'A'. However...
In your example, is there any way that I can type in 15* in cell A7, vlookup would recognize it for other cells, but only 15 will be displayed in A7?
I basically want to know if I can type out 15*, 15_, and only have the 15 show. Or is there a formating style that will only display the first 2...
Can I place a label in a cell, and have one of the characters remain hidden while viewed?
My situation is as follows;
On one sheet, I have a list of structures all labeled with numbers. On a seperate sheet, I type in the number I want, and use VLOOKUP to fill in the remaining results for each...
I'm having problems getting this to work. Do you just use a simple run command in the command button code?
I basically want to click a given button and the macro will start.
I ran the script and it would only copy the sheets and then stop.
However, if i break it into two different macros, i can get the copying and the renaming to each work seperatly.
Im trying to see if the following problem is even do-able.
When doing traffic forecasting, i need to add/copy 2 new sheets in excel each time an additional intersection is started. By using the macro recorder, i have been successful in doing the following;
-copying from 2 previous sheets to...