Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2007 split vba modules out of workbook (like Access front end/back end)???
I have a workbook that has around 40 sheets, many with some sophisticated
formulas. as well as 2000 lines of VBA. The vba does the user and application security, screen resolution (zoom) and conducts the workflow. The way it exists now, the user could be allowed to patch a sheet formula (but shouldn't be necessary), but if a bug fix or enhancement was required in the code all the current sheets data would have to be re-keyed. Is there a way to split the code out of the workbook? Perhaps put it in an Add-in? Would that allow for a bug fix to be moved out to existing users? How do others (you) do it? Thank you for your advice. rick |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2007 split vba modules out of workbook (like Access front end/back end)???
See chip Pearson website. Make sure you read everyhing because you have to change a menu item in the worksheet menu tools - Options - Macro - Security. The files get saved as a BAS extension which is a text file that you can open with notepade. 'Programming In The VBA Editor' (http://www.cpearson.com/Excel/vbe.aspx) -- joel ------------------------------------------------------------------------ joel's Profile: 229 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=166247 Microsoft Office Help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 - Split and re-consolidate master workbook | Excel Programming | |||
Excel front-end and Access back-end? | Excel Programming | |||
Excel Front end Acces Back end | Excel Discussion (Misc queries) | |||
I can not get excel to print on front and back can anyone help me. | New Users to Excel | |||
How can I print on the front and back of a page in excel? | Excel Discussion (Misc queries) |