Excel - Macro run Form, save as macro disabled

  • onlyican.com
  • Mastermind
  • Mastermind
  • User avatar
  • Posts: 1589
  • Loc: Hants, UK

Post 3+ Months Ago

Hey all

I have a FoxPro application which saves the data into a txt file and then opens an Excel Spreadsheet which runs macros to get the information to update the spreadsheet.

I am adding a macro to force Save As on exit or save.

but I want to save the spreadsheet so the next time the sheet is opened, I want macros disabled so the sheet does not try and pull the data again.

Anyone know how this can be done

Thanks in advance.
  • Anonymous
  • Bot
  • No Avatar
  • Posts: ?
  • Loc: Ozzuland
  • Status: Online

Post 3+ Months Ago

Post Information

  • Total Posts in this topic: 1 post
  • Users browsing this forum: No registered users and 46 guests
  • You cannot post new topics in this forum
  • You cannot reply to topics in this forum
  • You cannot edit your posts in this forum
  • You cannot delete your posts in this forum
  • You cannot post attachments in this forum
 
cron
 

© 1998-2014. Ozzu® is a registered trademark of Unmelted, LLC.