Protection Macro

stumped · Apr 17th, 2002, 04:03 PM

I have a macro that protects all my worksheets. I have one tab that I unlocked some cells so that when it is protected the user can alter the contents. But everytime I protect the document using the macro the cells become locked again.

Do I have to write in the macro to unlock those cells prior to protecting it?

I have unlocked them, saved it. Then protected and it works, but if I use the macro to protect, then close the workbook and reopen the cells are locked again.

Help!

Jack in the UK · Apr 17th, 2002, 04:10 PM

best advice i can offer

follw what you wopuld do manulally tyo get the task automated, no shorts cuts VBA dont always shor cut just does what we can in 10 mins in 10 seconds VERY FAST..
suggest record it.. watch errors them recored as well

Apr 17th, 2002, 04:10 PM	#2
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	best advice i can offer follw what you wopuld do manulally tyo get the task automated, no shorts cuts VBA dont always shor cut just does what we can in 10 mins in 10 seconds VERY FAST.. suggest record it.. watch errors them recored as well __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 17th, 2002, 04:03 PM	#1
stumped New Member Join Date: Jan 2002 Posts: 9	I have a macro that protects all my worksheets. I have one tab that I unlocked some cells so that when it is protected the user can alter the contents. But everytime I protect the document using the macro the cells become locked again. Do I have to write in the macro to unlock those cells prior to protecting it? I have unlocked them, saved it. Then protected and it works, but if I use the macro to protect, then close the workbook and reopen the cells are locked again. Help!