Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
 
Posts: n/a
Default Disabling click and right-click on the Picture I inserted in an Excel document

Hi,
I inserted a picture in the worksheet via Insert~Picture. Currently to
a. disable a Click I wrote an empty macro and
b. to disable right click I protected the sheet only the objects (this
also protects the Click)
issue with this all objects on the sheet got protected.

Is there a way only certain pictures inserted into the sheet be
disabled from click and right-click either by macro or some other way.

Thanks
Richie.

  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Marcelo
 
Posts: n/a
Default Disabling click and right-click on the Picture I inserted in an Ex

right click on the figure PROPERTIES | UNBLOCK

Then you protect the spreadsheet

Regards from Brazil
Marcelo

" escreveu:

Hi,
I inserted a picture in the worksheet via Insert~Picture. Currently to
a. disable a Click I wrote an empty macro and
b. to disable right click I protected the sheet only the objects (this
also protects the Click)
issue with this all objects on the sheet got protected.

Is there a way only certain pictures inserted into the sheet be
disabled from click and right-click either by macro or some other way.

Thanks
Richie.


Reply
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



All times are GMT +1. The time now is 05:13 AM.

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

About Us

"It's about Microsoft Excel"