View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Michael Lockwoo
 
Posts: n/a
Default Unable to Open File Error


Ok, Ladies and Gentlemen,

I'm at my wits end with this.

I have a excel file that uses the Workbook_open event to pop up a
inputbox asking for the individual's initials so I can log their
activity. This is placed in a hidden cell and used to call at will.

With that input box, when the file is opened, an error comes up telling
me it's unable to open/read the file and then repairs it and strips my
pivottable out of the worksheet.

Without the inputbox, the file works fine, as intended.

Any ideas?

Michael J. Lockwood


--
Michael Lockwoo


------------------------------------------------------------------------
Michael Lockwoo's Profile: http://www.excelforum.com/member.php...o&userid=31811
View this thread: http://www.excelforum.com/showthread...hreadid=551993