Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Macro not showing in Excel spreadsheet

I have received a spreadsheet from someone else that
contains a macro. When I open the spreadsheet, I get the
macro warning but when I go into Tools/Macro/Macro, i do
not see it in the list. Is there something else the user
who sent it to me needs to do?
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default Macro not showing in Excel spreadsheet

If the macro is marked as

Private Sub

or if the module is marked as private,

the macro will not appear in Tools/Macro/Macros.


Also, you can get a macro warning and not have any macros in the workbook.

--
Regards,
Tom Ogilvy

"Laura G" wrote in message
...
I have received a spreadsheet from someone else that
contains a macro. When I open the spreadsheet, I get the
macro warning but when I go into Tools/Macro/Macro, i do
not see it in the list. Is there something else the user
who sent it to me needs to do?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to fix my spreadsheet from showing formula to showing answer SimplyQuick Excel Discussion (Misc queries) 4 October 7th 08 10:00 PM
How to fix my spreadsheet from showing formula to showing answer SimplyQuick Excel Discussion (Misc queries) 0 October 7th 08 06:38 PM
'Calculation' showing on my excel spreadsheet (VLookups don;t work Fisher99 Excel Discussion (Misc queries) 2 May 28th 08 10:56 AM
showing data in a different way based on a spreadsheet excel 07 newyorkjoy Excel Discussion (Misc queries) 16 May 21st 07 08:18 PM
Excel Spreadsheet Trace Precedent Bars not showing up MarieM Excel Worksheet Functions 1 February 9th 07 07:57 PM


All times are GMT +1. The time now is 06:02 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"