I'm trying to display the same picture on multiple sheets without copying it.
The picture will be shown or hidden depending upon conditions.
I can achieve this using
But when I call it from another sheet it does not display
Please Login or Register to view this content.
Sounds simple but stumped me.
Thanks in advance.
Last edited by berty2000; 01-31-2019 at 07:22 AM.
Your post does not comply with Rule 2 of our Forum RULES. Use code tags around code.
Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.
Click on Edit to open your thread, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here
It can't be displayed because you've got ActiveSheet.Shapes, it works only on this sheet where you are.
if you want to display pictures on each of sheets, you have to loop through all sheets in workbook and make it visible.
Try like below:
Formula:
Please Login or Register to view this content.
should works (not tested).
Be sure that picture exists on each of sheets and always has a name 'picture4'
Happy with my answer * Add Reputation.
If You are happy with solution, please use Thread tools and mark thread as SOLVED.
Lovely that worked perfectly for what i need, Cheers
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks