Macro lovers

  • Thread starter Thread starter Steven
  • Start date Start date
S

Steven

anyone like writing macros? or know where i could findout how to write one
for this?

im after one that will do the following, with a button;

Sheet name = Totals
unhide colum A
Select Cells A2:J84
Select>Tools>Options>View>Showplaceholders
Select A1>dropdown>Show
hide colum A
Select>Tools>Options>View>Hide all
End

or does anyone know if this will make my rows auto hide or show when data is
on them? colum A has =IF(OR(B2="",B2=0),"Hide","Show) guess i can test it
while i wait :)

Thanks again everyone!

Steve
 
You like macros. Try recording a macro while you do these actions. Here's
part.

Sub Macro5()
'
' Macro5 Macro
' Macro recorded 4/13/2004 by Don Guillett
'

'
ActiveWorkbook.DisplayDrawingObjects = xlPlaceholders
ActiveWorkbook.DisplayDrawingObjects = xlAll
End Sub
 
Back
Top