Insert picture on a protected worksheet

Saa62 · Apr 29th, 2002, 06:43 PM

I need to keep a worksheet protected to protect the formulas, but need to be able to insert pictures. I have the cells unlocked where the pictures are to be inserted. With the sheet protected the option is not available to insert pictures from file. What does it take to work around this?

Thanks

Scott

Mark O'Brien · Apr 29th, 2002, 07:04 PM

VBA, even then it's not really a workaround.

Your macro would unprotect the sheet, add the picture, then protect the sheet again.

Apr 29th, 2002, 07:04 PM	#2
Mark O'Brien MrExcel MVP Join Date: Feb 2002 Location: Columbus, OH, USA Posts: 3,519	VBA, even then it's not really a workaround. Your macro would unprotect the sheet, add the picture, then protect the sheet again. __________________ Mark O'Brien Columbus Ohio Celtic Supporters Club

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

Apr 29th, 2002, 06:43 PM	#1
Saa62 New Member Join Date: Mar 2002 Posts: 20	I need to keep a worksheet protected to protect the formulas, but need to be able to insert pictures. I have the cells unlocked where the pictures are to be inserted. With the sheet protected the option is not available to insert pictures from file. What does it take to work around this? Thanks Scott