macro to open excel file with auto macro enable

In my excel sheet, I have created 10 buttons and I want to link those buttons to open different excel sheets (auto macro enable) in different location so I can work with instead of going here and there everyday.

Anyone have this macro?

Regards,

If you are asking for code that will open an excel sheet and force macros to be enabled, I don't think this is possible.

I see... I think it is security issue.

Then any code that can open a excel sheet?

Regards,

Please Login or Register  to view this content.

Any code to open a folder instead?

Regards,

http://stackoverflow.com/questions/1...lorer-from-vba

Thanks for the help ragulduy, but I forgot to specify that my folder is located on a http server folder such \\[domain_name.net\work\

Any working code out there?

Regards

Shouldn't make a difference.

The code would just do the same as typing whatever address you put in the explorer bar. I've tried it with ftp, http and network drives and all seems ok.

How would you normally access the server folder?

Thanks ragulduy, it is working perfectly. I removed the 1st part of the script wtihout notifying. Sorry, my bad.