LOCKED EXCEL SHEET

prninja · Apr 25th, 2002, 11:37 AM

Our company has made an Engineering Change sheet and locked it. When someone accesses it, they are supposed to rename the file to the particular name per company standards.
When just typing in the particular areas works fine, when someone tries to paste or insert a small picture (e.g. part of a drawing) they get the message "Microsoft Excel cannot paste the data"
How can I get rid of this but still keep certain parts of the sheet protected

Asala42 · Apr 25th, 2002, 11:48 AM

Hiya,

I'm taking a wild guess here - but under Toolsprotectionprotect sheet do you have the Objects checked for protection? If so, can you get away with removing Object protection (I'm not sure how to unlock a specific object for example).

Hope that helps somewhat,
Adam

Jack in the UK · Apr 25th, 2002, 04:02 PM

do you still need help?

Apr 25th, 2002, 04:02 PM	#3
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	do you still need help? __________________ 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 25th, 2002, 11:37 AM	#1
prninja New Member Join Date: Apr 2002 Posts: 2	Our company has made an Engineering Change sheet and locked it. When someone accesses it, they are supposed to rename the file to the particular name per company standards. When just typing in the particular areas works fine, when someone tries to paste or insert a small picture (e.g. part of a drawing) they get the message "Microsoft Excel cannot paste the data" How can I get rid of this but still keep certain parts of the sheet protected

Apr 25th, 2002, 11:48 AM	#2
Asala42 Board Regular Join Date: Feb 2002 Location: Southfield,MI USA Posts: 1,030	Hiya, I'm taking a wild guess here - but under Toolsprotectionprotect sheet do you have the Objects checked for protection? If so, can you get away with removing Object protection (I'm not sure how to unlock a specific object for example). Hope that helps somewhat, Adam