mvnForum Homepage

Print at May 31, 2020 10:18:10 PM

Posted by BehindCurtai at Mar 7, 2006 8:13:00 PM
Re: The Shop Tool
I can not figure out how to expose the macros for editing. Nor can I figure out how to unhide the hidden columns. (Simply right-clicking on the line between column A and column M and selecting "Show" does not work.)

To show hidden columns:
Select both of the visable columns on the sides (such as both A and M). Now right click and select show. All columns between A and M will be shown.

There are more Error: 504 in the investor section, but I don't see any !'s or .'s in the forumlas.

To show the macros: Tools -> Macros -> Organize macros -> Basic.
In the listbox that appears, select the item that corresponds to the spreadsheet (filename) (not the generic macros), and drill down through the plus's.

It appears to be organized by sheet. The macros appear to be:

Rem Attribute VBA_ModuleType=VBADocumentModule
Sub Sheet1
Rem Private Sub CommandButton1_Click()
Rem With Columns("G:L")
Rem .Hidden = Not .Hidden
Rem End With
Rem End Sub
Rem Private Sub CommandButton2_Click()
Rem With Columns("R:W")
Rem .Hidden = Not .Hidden
Rem End With
Rem End Sub
End Sub

Why they are all "Rem"'d out, I have no idea.

I have not (yet) figured out how the macros are triggered. (what turns the button press into the macro run).
"We're trying to find the error bars on that number"

Dylan wrote: 
Why buy sham poo when real poo is so readily available

Puzzle Pirates™ © 2001-2016 Grey Havens, LLC All Rights Reserved.   Terms · Privacy · Affiliates