About Us

Harry G

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 -

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel 2007 enabling macros	Johan U	Excel Discussion (Misc queries)	3	September 20th 07 07:12 PM
Excel 2007 Enabling Macros	Ang	Excel Discussion (Misc queries)	3	May 17th 07 09:59 AM
Enabling Visual Basic in Excel 2007	RandyS	Excel Discussion (Misc queries)	1	March 31st 07 11:10 AM
Enabling Macros	Old Music Lover	Excel Discussion (Misc queries)	2	July 23rd 05 02:07 AM
macros not enabling	James[_10_]	Excel Programming	2	September 4th 03 03:04 PM

Menu

About Us