copy of Macro Enabled workbook shows no macros

kvrogers
kvrogers used Ask the Experts™
on
I have  a user who sent me a copy of a MacroEnabled workbook that I originally created for another user.  She wants me to edit it by adding names to the macro.  When I click on VIEW MACROS it is blank.  

How must the user save and send me the Workbook in order for me to see the Macros.

KR
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2015
Commented:
Kr,

If the user is sending the excel directly by clicking on file-->save & send -->send using & email..You will get file with extension .xlsx which doesn't have macros in it.

Now in order for you to see the macro ask..the user to save it as .xlsm first which option he get in save as type-->excel macro enabled workbook..

Then ask him to send it to you and you will be able to see the macros...

Saurabh...
Martin LissOlder than dirt
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
I don't want any points for this but to expand on Saurabh's post, the types you can use are xlsm and xls.
...or ".xlsb".

Author

Commented:
Thanks.
KR

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial