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: 172
Default Menu Issues when creating an Add-in

I have just created an auditing tool for Excel. It is a
spreadsheet which opens up and has its own menu. I now
want to covert it into an Excel Add-in. However I am not
clear what changes, if any, need to be made to my menu
creation code.

In the xls version, I have a Workbook_Open event that
creates the menu and a Workbook_Close Event that Deletes
the menu. If I now covert it to an xla file(Add-in), does
Excel treat it as an open file? Will it always display my
menu? That is, once clicked as an Add-in, will the menu
deletion code that I have in my Workbook_Close event
become redundant?

Is there anything I should know before converting this to
an xla file?

Thank-you
 
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
Suggestions for creating Issues Log using Excel? Deb Excel Worksheet Functions 1 March 14th 05 03:38 PM
AddName - issues w/ creating with reference to a diffferent workbook. Mark J Kubicki Excel Programming 3 January 15th 05 11:05 PM
Creating a menu Frenchy Excel Worksheet Functions 1 December 11th 04 03:35 PM
Excel menu toolbar hyperlink issues Cliff[_3_] Excel Programming 6 August 20th 04 09:31 PM
Creating a drop-down menu Ron de Bruin Excel Programming 0 September 16th 03 06:33 PM


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