LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 17
Default run time error 32809

I am running Excel 2010/Windows 7 on a large network. I've recently updated an application that was originally written 4+ years ago and has been enhanced throughout the years. The latest version works fine on my machine, but some users are getting the following error upon opening the macro:

Run-time error '32809'
Application-defined or object-defined error

The trigger is the following code in sheet 'ThisWorkbook'

Private Sub Workbook_Open()
Application.ScreenUpdating = False
Sheets("Instructions").Activate
Application.ScreenUpdating = True
End Sub

The error is pointing to the "Instructions" sheet (in this case it is also Sheet33

Any suggestions as to why this is happening?

Art
 
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
Run-time error 57121 & 32809, Excel 2003 SP2 Adrian C[_2_] Excel Programming 2 July 25th 12 12:43 PM
Runtime Error 32809 Lance Roberts Excel Programming 3 March 9th 09 06:52 PM
Error handling error # 1004 Run-time error [email protected] Excel Programming 3 May 20th 08 02:23 PM
unexpected error (32809) Student Excel Programming 7 February 6th 07 07:24 PM
Errors 32809 and 57121 :-( Jan[_18_] Excel Programming 0 June 3rd 06 05:56 PM


All times are GMT +1. The time now is 04:46 PM.

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

About Us

"It's about Microsoft Excel"