Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: smaca
  • Order by date
  1. smaca

    Excel file size - could macro cause?

    True, but doing it that way does seem better. It's leaving me with a file of 1MB. Bigger than the 100kb it should be but better than 8MB!
  2. smaca

    Excel file size - could macro cause?

    That's a good suggestion. Thanks for that Geoff.
  3. smaca

    Excel file size - could macro cause?

    There are about 40 checkboxes, they don't drive any macros but are linked to cells for true/false which is used in other formulas. There are 8 buttons, all of which have code behind them. The code would need to function in any new reproduced sheet. As I mentioned before, the original version...
  4. smaca

    Excel file size - could macro cause?

    I was afraid you'd say that! It's not that practical as there are a lot of controls on it, links to/from other sheets and it would be something approaching a nightmare to have to replicate it in a new sheet...
  5. smaca

    Excel file size - could macro cause?

    First time poster - have checked through previous threads without success but apologies if I've missed an answer to this. I have a file (call it the Master file), which is about 25MB. I run a macro to copy 6 of the sheets from this file to another file (call it the Backup file). This file is...

Part and Inventory Search

Back
Top