LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default Accessing worksheets in xla add-in file

in the properties of the workbook, change isaddin to false. When done,
change it back.

You can reference the addin from the addin using ThisWorkbook.

--
Regards,
Tom Ogilvy

"ExcelMonkey" wrote in message
...
I have some sheets in my add-in file. how can I acces them manually.

That
is, you cannot see them when using the file as an Add-in.

Secondly, if I wanted to access data in these sheets, can I simply use the
Thisworkbook Object to do so?

Thanks



 
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
what exactly prevents INDIRECT from accessing closed worksheets? z.entropic Excel Worksheet Functions 3 July 24th 07 03:02 PM
accessing worksheets greg Excel Worksheet Functions 2 November 2nd 04 03:53 PM
accessing worksheets greg Excel Programming 2 November 2nd 04 03:53 PM
Question about accessing worksheets on an AddIn file 39N95W Excel Programming 1 May 25th 04 03:11 AM
programatically accessing Macros in worksheets Patrick[_8_] Excel Programming 1 April 15th 04 08:41 PM


All times are GMT +1. The time now is 03:00 AM.

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"