View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ann ann is offline
external usenet poster
 
Posts: 210
Default disable shape resizing or moving

Hi,
Iam currently working on a pivot report in excel. since i cannot use sheet
protection to lock cells because the pivot needs to be refreshed, i found
another way to make it uneditable... i used macro. now i have a slight
problem... i dont know how to disable the resizing and moving of the shapes
in the sheet. even rightclick doesnt seem to work with shapes.. any help is
greatly appreciated :) thank you so much...
i need to achieve the following:
the shapes in the sheet cannot be move, cannot be sized..and if possible
cannot be selected :)