Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 73
Default Macro Hidden - Cannot "Edit" to see code

In the company I work for there is a workbook that takes CSV files and
formats into reports via macros in a central workbook. This thing is really
cool, and I want to see the macro code to learn how it works.

When I goto "tools", "macro", "macros" I can see the macro names, but the
"edit" button is greyed out for all of them.

Is there a way I can see the code?

Thanks,

Scott
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,345
Default Macro Hidden - Cannot "Edit" to see code

The original code writer has protected VBA to prevent you doing exactly
that. Ask them for the password.

--

Sandy

In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"porter444" wrote in message
...
In the company I work for there is a workbook that takes CSV files and
formats into reports via macros in a central workbook. This thing is
really
cool, and I want to see the macro code to learn how it works.

When I goto "tools", "macro", "macros" I can see the macro names, but the
"edit" button is greyed out for all of them.

Is there a way I can see the code?

Thanks,

Scott



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
"edit query" button in Excel 2007 has been hidden Andre Ranieri Excel Worksheet Functions 2 May 2nd 23 03:44 AM
why do i "sometimes" need to "edit chart object" before "source da Flirty and Blonde Charts and Charting in Excel 1 February 2nd 10 02:07 PM
"Reference not valid" error when I try to edit the macro in excel Yuvaraj Excel Discussion (Misc queries) 1 January 10th 08 08:32 PM
Lost "File Menu" - now it's "Edit / View / Insert.." but no "F daves Excel Discussion (Misc queries) 3 April 24th 07 04:52 AM


All times are GMT +1. The time now is 03:49 PM.

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

About Us

"It's about Microsoft Excel"