Locked object
Solved
Hello
In a spreadsheet, to protect calculation formulas, I inserted a photo.
I don't know how, when I want to move this photo via a macro, I get the message
The requested shapes are locked for selection.
I don't know what to do...
If anyone has an idea, I've tried
Sh.Locked=False
Sh.Select
Nothing works.
Phil97214
In a spreadsheet, to protect calculation formulas, I inserted a photo.
I don't know how, when I want to move this photo via a macro, I get the message
The requested shapes are locked for selection.
I don't know what to do...
If anyone has an idea, I've tried
Sh.Locked=False
Sh.Select
Nothing works.
Phil97214
Related links:
- [Excel vba] Issue with macro assignment -> object
- Excel & VB - Retrieve the name of the clicked object
- VBA Excel, block clicks on objects
- [VBA] Operation not allowed for this type of object.
- The Copy method of the Range object has failed.
- Object variable or With block variable not set: Runtime error 91
3 answers
-
ContributorHello, I have an idea: give us useful factual information.
For example, to start, share your file. -
Hello,
Thank you for looking into my problem, but I don't know how to attach a file to my response. (I'm terrible with the internet!)
Phil97214 -
In fact, I restarted my workbook from a backup, I had to update it but it works. I should have kept the faulty workbook to study the problem, but I only thought of that afterward. Too bad.
I consider my problem resolved. Thank you
Phil97214
