Hello, I have a question which I did not find an answer for n any forum.
I am creating a company-wide macro that allows people to format a blank sheet as per company standard. This involves inserting a logo (picture) on the top left of the sheet. This picture will be saved on their desktop.
HOWEVER, I don't want the macro to ask the user to Browse the picture from the desktop EVERY TIME they run the formatting macro, but ONLY THE FIRST TIME.
In other words:
FIRST TIME THE USER RUNS THE MACRO:
- VBA code will ask the user to browse the picture
- The sheet will be formatted with the logo selected by the user
NEXT TIME THE USER RUNS THE MACRO:
- The sheet will be formatted with the logo which can be found at the same path as the first time the user ran the macro
I hope it's clear
Thanks
Niccolo'
I am creating a company-wide macro that allows people to format a blank sheet as per company standard. This involves inserting a logo (picture) on the top left of the sheet. This picture will be saved on their desktop.
HOWEVER, I don't want the macro to ask the user to Browse the picture from the desktop EVERY TIME they run the formatting macro, but ONLY THE FIRST TIME.
In other words:
FIRST TIME THE USER RUNS THE MACRO:
- VBA code will ask the user to browse the picture
- The sheet will be formatted with the logo selected by the user
NEXT TIME THE USER RUNS THE MACRO:
- The sheet will be formatted with the logo which can be found at the same path as the first time the user ran the macro
I hope it's clear
Thanks
Niccolo'