Ok this may be kind of hard to explain without having an example. This will be accross 51 workbooks that i can have open all at one time. They all have the same tabs, and passwords and in general same line/column configuration.
1 unlock all the worksheets that are titled "Budget"
2 go to cell P5 in "Budget" and if Q5 is 0 or higher link to tab "Prior" P5; if not 0 or higher leave blank (the spreadsheet also contains = and - i do not want those to be picked up)
3 go to cell S5 in "Budget" and if Q5 is 0 or higher link to tab "Delta" P5;if not 0 or higher leave blank (the spreadsheet also contains = and - i do not want those to be picked up)
4 do the above to line 250
5 lock all spreadsheets named "Budget" with "the password I choose"
Please help!!! this needs to be done by tomorrow evening and it took me 2 weeks to build the spreadsheets in the first place. I have another problem too please see the other
See response in your other thread. Multiple threads for the same question is a big no-no.
http://www.excelforum.com/excel-gene...edit-data.html
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.
Thread Closed.
Hope that helps.
RoyUK
--------
If you are pleased with a member's answer then use the Star icon to rate it, if you are pleased enough to part with cash consider a donation to Children in Need
For Excel Tips & Solutions, free examples and tutorials why not check out my downloads
New members please read & follow the Forum Rules
Remember to mark your questions Solved and rate the answer(s)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Bookmarks