Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
getting error
environment excel97.
I run a macro, look at its code and paste it into my VB code. Im getting an error. What could be wrong? Will I get an error if conditions allready are true? thank You regards jan Private Sub Worksheet_Activate() With ActiveWindow .DisplayFormulas = False .DisplayGridlines = False .DisplayHeadings = False .DisplayOutline = False .DisplayZeros = False .DisplayHorizontalScrollBar = False .DisplayVerticalScrollBar = False .DisplayWorkbookTabs = True End With ActiveSheet.DisplayPageBreaks = False End Sub |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
getting error
Jan,
What error are you getting, and on what line does the error occur? -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Jan Eikeland" wrote in message ... environment excel97. I run a macro, look at its code and paste it into my VB code. Im getting an error. What could be wrong? Will I get an error if conditions allready are true? thank You regards jan Private Sub Worksheet_Activate() With ActiveWindow .DisplayFormulas = False .DisplayGridlines = False .DisplayHeadings = False .DisplayOutline = False .DisplayZeros = False .DisplayHorizontalScrollBar = False .DisplayVerticalScrollBar = False .DisplayWorkbookTabs = True End With ActiveSheet.DisplayPageBreaks = False End Sub |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
getting error
Whats the error ?
"Jan Eikeland" wrote in message ... environment excel97. I run a macro, look at its code and paste it into my VB code. Im getting an error. What could be wrong? Will I get an error if conditions allready are true? thank You regards jan Private Sub Worksheet_Activate() With ActiveWindow .DisplayFormulas = False .DisplayGridlines = False .DisplayHeadings = False .DisplayOutline = False .DisplayZeros = False .DisplayHorizontalScrollBar = False .DisplayVerticalScrollBar = False .DisplayWorkbookTabs = True End With ActiveSheet.DisplayPageBreaks = False End Sub |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
getting error
hi tks fer answer.
runtime error 1004 : Cant give display-formulas proerty to window class. tks jan "Chip Pearson" skrev i melding ... Jan, What error are you getting, and on what line does the error occur? -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Jan Eikeland" wrote in message ... environment excel97. I run a macro, look at its code and paste it into my VB code. Im getting an error. What could be wrong? Will I get an error if conditions allready are true? thank You regards jan Private Sub Worksheet_Activate() With ActiveWindow .DisplayFormulas = False .DisplayGridlines = False .DisplayHeadings = False .DisplayOutline = False .DisplayZeros = False .DisplayHorizontalScrollBar = False .DisplayVerticalScrollBar = False .DisplayWorkbookTabs = True End With ActiveSheet.DisplayPageBreaks = False End Sub |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
getting error
hi, tks fer answer.
runtime errror 1004 : cant give displayformulas property to window class. regards jan "Chris Leonard" skrev i melding ... Whats the error ? "Jan Eikeland" wrote in message ... environment excel97. I run a macro, look at its code and paste it into my VB code. Im getting an error. What could be wrong? Will I get an error if conditions allready are true? thank You regards jan Private Sub Worksheet_Activate() With ActiveWindow .DisplayFormulas = False .DisplayGridlines = False .DisplayHeadings = False .DisplayOutline = False .DisplayZeros = False .DisplayHorizontalScrollBar = False .DisplayVerticalScrollBar = False .DisplayWorkbookTabs = True End With ActiveSheet.DisplayPageBreaks = False End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 - error saving file & error loading dll | Excel Discussion (Misc queries) | |||
Counting instances of found text (Excel error? Or user error?) | Excel Worksheet Functions | |||
I have Error 1919 Error Configuring ODBC dataSource Database | Excel Discussion (Misc queries) | |||
Excel 2003 Macro Error - Runtime error 1004 | Excel Discussion (Misc queries) |