BjornBehr
asked on
Changing Excel Logo & VBA warning
1) In excel how do you go about changing the Excel logo (Top left of screen) through VB/VBA?
2) Is it at all possible to stop the Macro warning from poping up in Office through VB/VBA?
Regards
Bjorn
2) Is it at all possible to stop the Macro warning from poping up in Office through VB/VBA?
Regards
Bjorn
1. is not possible without hacking the program as far as i'm aware.
2. Tools > Options> Security Tab > Macro Security Button
Hope this helps
Marion
2. Tools > Options> Security Tab > Macro Security Button
Hope this helps
Marion
Bjorn
1. With win32 APIs on the window. The change will be temporary
(until you close the main window application).
2. Through VB/VBA. I would say No, but not sure.
Changing the security level would change security for all
workbooks... not very safe.
Maybe you could sign your code (using certif) so once approved
by the user one time it would not request any approval aftre that, neither show warning.
Probably some better ways to do that out there.
Sébastien
1. With win32 APIs on the window. The change will be temporary
(until you close the main window application).
2. Through VB/VBA. I would say No, but not sure.
Changing the security level would change security for all
workbooks... not very safe.
Maybe you could sign your code (using certif) so once approved
by the user one time it would not request any approval aftre that, neither show warning.
Probably some better ways to do that out there.
Sébastien
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks all.
* for the Application, you might try to "hack" the excel.exe file to replace the excel icons...
* in the Explorer, you can easily (view change file type ...), but that's not the question here...
2) Application.DisplayAlerts = false
CHeers