Hi everyone.
Please can someone help I have a worksheet that contains some macros
when i locked and hide formulas with a password and when i work with the worksheet
i cannot run the macros i got message debug... end... etc
Hi everyone.
Please can someone help I have a worksheet that contains some macros
when i locked and hide formulas with a password and when i work with the worksheet
i cannot run the macros i got message debug... end... etc
You will need to unlock the sheet at the front of the macro and then reprotect it at the end.
You can protect with UserInterface, see example here, or as Barry suggests
Please Login or Register to view this content.
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
hanks for the rep
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Or you can use this way:
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks