Thanks. I will look into thiese solutions.

Harry G

" wrote:

Harry,

Take a look at these free solutions:
http://orlando.mvps.org/ExcelFreeMore.asp?IdC=help
or
http://orlando.mvps.org/XLtoExeMore.asp?IdC=help


On Aug 19, 3:19 pm, Harry G wrote:
Jim,

I forgot to add that I would like to automate to enable macros for user to
get into the file when file opens and go back to the security (e.g. disable
macros when the user close the file).

Just like leaving the spreadsheet in the default before close of the file..

Thanks.

Harry G



"Jim Rech" wrote:
I would rather automate to activate macros when the file is open

But you see the purpose of macro security is to keep malicious code from
running, at least without the user's permission. If a macro itself could
turn off that security it wouldn't be worth very much.

--
Jim
"Harry G" wrote in message
...
| Jim,
|
| This may sound stupid but I just upgraded toExcel2007. I suppose I have
| to tell other users to put the file in Trusted Place?
|
| I would rather automate to activate macros when the file is open since I
| have a user form for entering passwrod for users to use the file. This
| workbook was created with macros inExcel2003.
|
| Thanks.
|
| Harry G
| "Jim Rech" wrote:
|
| You might try putting your workbook in one of the Trusted Places
specified
| in the Trust Center.
|
| --
| Jim
| "Harry G" wrote in message
| ...
| |I just upgraded toExcel2007fromExcel2003. My macros (which
include
| | menus I added on theExcelBar) do not open inExcel2007.
| |
| | I noticed that the macro security has to be enabled. However when I
do
| that
| | my custom menus on theExcelmenu bar are not enabled.
| |
| | Could anybody help me to automate enabling the macros when I open my
| | workbook. I do not want to save the file with enabled macros.
| |
| | Any help will be greatly appreciated.
| |
| | Thanks.
| |
| | Harry
|
|
| - Hide quoted text -

- Show quoted text -