unprotecting sheet error

Jordy · Apr 1st, 2002, 07:37 AM

I have a small problem with an Excel macro. I am trying to unprotect a sheet using the following code....

sheet1.select
sheet1.unprotect

should be simple, but this causes an error. If I select a cell on the sheet explicitly then it works okay ie if I use

sheet1.cells(1,1).select
sheet1.unprotect

does anybody know why?????

Al Chara · Apr 1st, 2002, 07:59 AM

I am using excel2000 and your code worked for me.

Tom Schreiner · Apr 1st, 2002, 09:35 AM

Hi
If you are running your code from a command button, set it's TakeFocus******* Property to false.
Tom

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

Apr 1st, 2002, 07:37 AM	#1
Jordy New Member Join Date: Mar 2002 Posts: 2	I have a small problem with an Excel macro. I am trying to unprotect a sheet using the following code.... sheet1.select sheet1.unprotect should be simple, but this causes an error. If I select a cell on the sheet explicitly then it works okay ie if I use sheet1.cells(1,1).select sheet1.unprotect does anybody know why?????

Apr 1st, 2002, 07:59 AM	#2
Al Chara MrExcel MVP Join Date: Feb 2002 Location: Monterrey, Mexico Posts: 1,433	I am using excel2000 and your code worked for me.

Apr 1st, 2002, 09:35 AM	#3
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	Hi If you are running your code from a command button, set it's TakeFocus******* Property to false. Tom