Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
too many macros
Hi, I've written an application that will be used to drive a loca wrestling tournament. I have quit a bit of VB code with many macros. The problem is the worksheet takes way too long to save. The peopl running the tournament will be constantly going in and out of severa worksheets (files) and it's real painful to wait around 20 seconds t save each file after simply updating a cell or two. Is there a way to write a special "save" macro that saves only the dat in the cells and not the many macros that I have? Thanks for your help -- opie ----------------------------------------------------------------------- opiec's Profile: http://www.excelforum.com/member.php...nfo&userid=496 View this thread: http://www.excelforum.com/showthread.php?threadid=27599 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
too many macros
Nothing that allows you to separate the code from the worksheets in a single
workbook. But have you thought about separating your code from your workbook? You could create a toolbar that runs your macros against the active workbook. Then you save just the workbook with the data. opiec wrote: Hi, I've written an application that will be used to drive a local wrestling tournament. I have quit a bit of VB code with many macros. The problem is the worksheet takes way too long to save. The people running the tournament will be constantly going in and out of several worksheets (files) and it's real painful to wait around 20 seconds to save each file after simply updating a cell or two. Is there a way to write a special "save" macro that saves only the data in the cells and not the many macros that I have? Thanks for your help! -- opiec ------------------------------------------------------------------------ opiec's Profile: http://www.excelforum.com/member.php...fo&userid=4963 View this thread: http://www.excelforum.com/showthread...hreadid=275999 -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
too many macros
How do you do this - is there anywhere I can read up on this technique?
BowMag "Dave Peterson" wrote in message ... Nothing that allows you to separate the code from the worksheets in a single workbook. But have you thought about separating your code from your workbook? You could create a toolbar that runs your macros against the active workbook. Then you save just the workbook with the data. opiec wrote: Hi, I've written an application that will be used to drive a local wrestling tournament. I have quit a bit of VB code with many macros. The problem is the worksheet takes way too long to save. The people running the tournament will be constantly going in and out of several worksheets (files) and it's real painful to wait around 20 seconds to save each file after simply updating a cell or two. Is there a way to write a special "save" macro that saves only the data in the cells and not the many macros that I have? Thanks for your help! -- opiec ------------------------------------------------------------------------ opiec's Profile: http://www.excelforum.com/member.php...fo&userid=4963 View this thread: http://www.excelforum.com/showthread...hreadid=275999 -- Dave Peterson |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
too many macros
if you're writing about creating the interface to your macros:
I like the way John Walkenbach did it in his menumaker.xls workbook. http://j-walk.com/ss/excel/tips/tip53.htm It's easy to update and looks really professional. And for toolbars, I like this: http://groups.google.com/groups?thre...5B41%40msn.com I think I'd try to build a few sanity checks into each macro to see if you stop the user from running a macro that will break something if he/she isn't on the correct worksheet. if lcase(activesheet.range("a1").value) < "yourstandardheaderhere" then msgbox "wrong worksheet" exit sub end if You could even check the name of the worksheets if they don't vary (much). BowMag wrote: How do you do this - is there anywhere I can read up on this technique? BowMag "Dave Peterson" wrote in message ... Nothing that allows you to separate the code from the worksheets in a single workbook. But have you thought about separating your code from your workbook? You could create a toolbar that runs your macros against the active workbook. Then you save just the workbook with the data. opiec wrote: Hi, I've written an application that will be used to drive a local wrestling tournament. I have quit a bit of VB code with many macros. The problem is the worksheet takes way too long to save. The people running the tournament will be constantly going in and out of several worksheets (files) and it's real painful to wait around 20 seconds to save each file after simply updating a cell or two. Is there a way to write a special "save" macro that saves only the data in the cells and not the many macros that I have? Thanks for your help! -- opiec ------------------------------------------------------------------------ opiec's Profile: http://www.excelforum.com/member.php...fo&userid=4963 View this thread: http://www.excelforum.com/showthread...hreadid=275999 -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
convert lotus 123w macros to excel macros | Excel Programming | |||
Open workbook-macros enabled, opening another with macros | Excel Programming | |||
Macro Size Limit / open macros with macros? | Excel Programming | |||
Macros not appearing in the Tools Macro Macros list | Excel Programming | |||
Suppress the Disable Macros / Enable Macros Dialog | Excel Programming |