Enabling macros in Excel 2007
 

I just upgraded to Excel 2007 from Excel 2003. My macros (which include
menus I added on the Excel Bar) do not open in Excel 2007.

I noticed that the macro security has to be enabled. However when I do that
my custom menus on the Excel menu 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

Enabling macros in Excel 2007
 

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 to Excel 2007 from Excel 2003. My macros (which include
| menus I added on the Excel Bar) do not open in Excel 2007.
|
| I noticed that the macro security has to be enabled. However when I do
that
| my custom menus on the Excel menu 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

Enabling macros in Excel 2007
 

Jim,

This may sound stupid but I just upgraded to Excel 2007. 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 in Excel 2003.

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 to Excel 2007 from Excel 2003. My macros (which include
| menus I added on the Excel Bar) do not open in Excel 2007.
|
| I noticed that the macro security has to be enabled. However when I do
that
| my custom menus on the Excel menu 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

Enabling macros in Excel 2007
 

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 to Excel 2007. 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 in Excel 2003.
|
| 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 to Excel 2007 from Excel 2003. My macros (which
include
| | menus I added on the Excel Bar) do not open in Excel 2007.
| |
| | I noticed that the macro security has to be enabled. However when I
do
| that
| | my custom menus on the Excel menu 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
|
|
|

Enabling macros in Excel 2007
 

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 to Excel 2007. 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 in Excel 2003.
|
| 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 to Excel 2007 from Excel 2003. My macros (which
include
| | menus I added on the Excel Bar) do not open in Excel 2007.
| |
| | I noticed that the macro security has to be enabled. However when I
do
| that
| | my custom menus on the Excel menu 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
|
|
|

Enabling macros in Excel 2007
 

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 -

Enabling macros in Excel 2007
 

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 -