LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 74
Default Editing a Chart on a protected worksheet

Hola,
I wonder if there is a way to allow the user to edit an embedded chart
within a protected worksheet. I know that setting the parameter
DrawingObjects=True (when protecting the worksheet) allows for editing while
protected. However, in the worksheet there are other shapes that I don't want
the user to be able to edit.
Is there a way accomplish this using VBA code?
Thank you in advance for your reponse.
OMER
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to permit editing the contents of added row(cells) if previous row is protected? [email protected] Excel Discussion (Misc queries) 1 January 19th 09 10:57 PM
Allowing editing locked cells in a protected sheet in excel phoenix[_2_] Excel Worksheet Functions 1 December 23rd 08 11:50 AM
Edit text format in non-protected cells in protected worksheet Bonnie Excel Discussion (Misc queries) 2 April 19th 08 04:48 PM
"Locked for Editing" error on a non-protected file Jim Murray Excel Discussion (Misc queries) 1 March 8th 08 11:42 AM
Editing a protected sheet Govind Rathi Excel Programming 6 October 12th 04 07:30 AM


All times are GMT +1. The time now is 06:57 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"