Hi guys. I now have the worksheet I wanted all done and as I have not used VBA before using this sheet I did knot know protecting it stopped my VBA from working.
What I am looking to know please is what is the code to unprotect the sheet then re- protect the sheet and where in the VBA should I put it?
there is no password it just to stop people changing/deleting things by accident.
here is an exstract of the code (thank you palmetto)
Please Login or Register to view this content.
Last edited by DonkeyOte; 11-24-2009 at 08:55 AM. Reason: tags revised to CODE from QUOTE
See this link: How To Run Macros On Protected Worksheets & Sheets
Palmetto
Do you know . . . ?
You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.
You will need to uprotect the sheet in the code, example
Please Login or Register to view this content.
gareth, I can see you've tried to comply by adding tags - however going forward could you please ensure you use CODE tags as opposed to QUOTE tags ?
manually: simply replace QUOTE with CODE
icons: use the # icon rather than the Quote icon to wrap selected text in appropriate tags
I have modified your first post on this occasion.
TIA
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
,
Bookmarks