View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
GS[_2_] GS[_2_] is offline
external usenet poster
 
Posts: 3,514
Default can i use VBA in one XLS file to change VBA in another?

What do you mean when you say "new tab names"? If you're referring to
worksheet tabs then your project needs a serious overhaul if it doesn't
work because a user renamed a sheet! OR do you intend to distribute a
'bandaid' for every user who renames a sheet?

Better (IMO) to properly rebuild your project!!!

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion