Sharing macros

[Lenny]

I am using Excel to develop some forms for my company. Once the master is
completed, it will be uploaded to a server and users will access it from a
repository. Do macros and vb code work the same in Excel as in Word? (i.e.,
..dot to doc). Once the employee downloads the master, can they share the
file while retaining the vb code or custom toolbars or do you run into the
same problems as in Word

 

[Lenny]

"lenny" replied: Joel - my thanks... though I think I was too simplistic.
My company stores all electronic form templates (word, excel) on a server.
Our IT department sets up each computer so the 'templates' are accessed thru
each of the programs FILE>NEW. I have been setting up Word templates for
years and understand the relationship between the master or user group
template and the saved .doc. Excel as a vehicle for e-forms is relatively
new. I'm trying to understand if Excel has the same relationship with it's
child files as word, especially in regards to vb programming.

The code, when written or copied into the vb editor of a .xls file, seems to
stay put, but I noticed that the custom toolbar I created in the .xls file
disappeared from the VIEW>TOOLBARS dropdown. I read in an obit that custom
toolbars do not pass with the files created off the master template. Are key
combinations lost also?

Regares - Lenny