Hello,
I am running the following code at workbook open:
I need this for the functioning of all the sheets except one that I just added. The new sheet will not function with the above settings, and should remain unprotected. Any help tweaking the code would be great. The name of the sheet that I don't want protected is "CBList".
Please Login or Register to view this content.
Thank you,
Jason
Last edited by Jason_2112; 11-11-2010 at 10:34 AM.
Please Login or Register to view this content.
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
Try
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
Perfect. I got Roy's to work, but the first one was giving an error when opening the workbook. Problem solved though. Thanks for the speedy help guys.
- Jason
No worries.
Code shouldn't have caused an error but at least you've got it sorted.
Dom
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks