unprotect commandbar when sheet protected

keithkemble · May 7th, 2002, 01:58 PM

When the sheet is protected the hyperlink button in the "standard" commandbar (1) greys out.

I wish to make this available when the sheet is protected.

I am having difficulty understanding the syntax even when I read Office unleashed.

Can anyone help with a one liner that will unprotect the hyperlink button when in protect mode.

Thanks.

Mudface · May 7th, 2002, 02:05 PM

This is by design, you can't do quite a number of things when the sheet is protected and, unfortunately in your case, Editing or Inserting hyperlinks is one of them.

keithkemble · May 7th, 2002, 02:15 PM

Can I at least create a toolbar "my bar" which would do what the hyperlink pop up would.

Unleashed implies you can create your own but I am unsure of the method.

Mudface · May 7th, 2002, 02:20 PM

You can create a toolbar, but the Hyperlink button wouldn't work when the sheet is protected, unfortunately. About the best you could do would be to have a button that unprotects the sheet first, but you might as well just do that from the Excel menu-bar, really.

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

May 7th, 2002, 01:58 PM	#1
keithkemble Board Regular Join Date: Feb 2002 Location: Leicestershire, U K Posts: 157	When the sheet is protected the hyperlink button in the "standard" commandbar (1) greys out. I wish to make this available when the sheet is protected. I am having difficulty understanding the syntax even when I read Office unleashed. Can anyone help with a one liner that will unprotect the hyperlink button when in protect mode. Thanks.

May 7th, 2002, 02:05 PM	#2
Mudface MrExcel MVP Join Date: Feb 2002 Location: Sunny, spring-like Hull Posts: 3,339	This is by design, you can't do quite a number of things when the sheet is protected and, unfortunately in your case, Editing or Inserting hyperlinks is one of them.

May 7th, 2002, 02:15 PM	#3
keithkemble Board Regular Join Date: Feb 2002 Location: Leicestershire, U K Posts: 157	Can I at least create a toolbar "my bar" which would do what the hyperlink pop up would. Unleashed implies you can create your own but I am unsure of the method.

May 7th, 2002, 02:20 PM	#4
Mudface MrExcel MVP Join Date: Feb 2002 Location: Sunny, spring-like Hull Posts: 3,339	You can create a toolbar, but the Hyperlink button wouldn't work when the sheet is protected, unfortunately. About the best you could do would be to have a button that unprotects the sheet first, but you might as well just do that from the Excel menu-bar, really.