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 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...
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.
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...
