Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,069
Default .visible property causing an error in Excel 97

I have a macro that blows up when any properties of a worksheet is referenced. When I view the watch window I can see that the current workbook is active and I can view all the properties of the worksheet. When I step into the line "If ActiveWorkbook.Worksheets("worksheet name").Visible = False Then"
it blows up.

The error is 'The instruction at "0x651b41d3" referenced memory at "0x0000004xc". The memory could not be read'.

Sometimes I can step through this error.
The error does not occur when mso9.dll is referenced but this dll is not present on all machines.

Any suggestions?
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
Formula causing run-time error in Excel Programming cherman Excel Worksheet Functions 2 March 15th 10 10:59 PM
Visible property on Worksheets Russell Lucas Excel Programming 5 February 5th 04 03:26 PM
Visible Property Steve A[_2_] Excel Programming 1 January 5th 04 12:35 PM
Run-time error '1004' - Unable to set the Visible property of the Worksheet class Shalin Chopra Excel Programming 3 November 25th 03 08:38 PM
.Visible Property Jollynicechap Excel Programming 1 July 8th 03 09:06 PM


All times are GMT +1. The time now is 12:04 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"