+ Reply to Thread
Results 1 to 12 of 12

code to protect formulas

  1. #1
    Forum Contributor
    Join Date
    06-23-2007
    Posts
    690

    code to protect formulas

    hi guys
    is there any hard code out there that protects formulas in a cell

    i have a sheet with formulas down a column
    that used once disappear
    is there any way to code this so they are always there?

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678
    Formulas don't disappear unless something disappears them, steve.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Forum Contributor
    Join Date
    06-23-2007
    Posts
    690
    hi shg
    i have it as a purchase order
    and it saves again as the original plus one more on the purchase order number
    but the formulas are then gone

  4. #4
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678
    and it saves again as the original plus one more on the purchase order number
    Sorry, I don't follow that.

    You have code doing something?

  5. #5
    Forum Contributor
    Join Date
    06-23-2007
    Posts
    690
    please find attached
    it may be easier to explain
    Attached Files Attached Files
    Last edited by stevesunfold; 12-08-2008 at 03:13 PM.

  6. #6
    Forum Contributor
    Join Date
    06-23-2007
    Posts
    690
    when i click and save the file ( button at bottom )( print copy and save )
    it will print 2 copies , copy the details form sheet 1 to sheet 2 , save the file to the specific folder and then reset the purchase order plus one more number
    ie w001 to w002
    the formulas will then be lost
    i would ideally like to save it as a pdf so it cant be altered

  7. #7
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678
    You have code that clears the formulas:
    Please Login or Register  to view this content.
    You also have a circular reference on that sheet that you should sort out.

  8. #8
    Forum Contributor
    Join Date
    06-23-2007
    Posts
    690
    any advice please shg would be gratefully received

  9. #9
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678
    Steve, I don't know what you're trying to do. Why are you clearing the formulas if you don't want them cleared?

  10. #10
    Forum Contributor
    Join Date
    06-23-2007
    Posts
    690
    i am trying to save the sheet to the specific folder as it does now

    but i really want it to save just the first sheet in to the specific folder as a pdf

    i then need it to clear the cells and save as a new order with the purchase order increasing by one

  11. #11
    Forum Contributor
    Join Date
    06-23-2007
    Posts
    690
    sometimes i have to manually input a number into a cell that has code that over writes it
    how can i get this so that next time i open it after its saved it will have the formula in the cell?

  12. #12
    Forum Contributor
    Join Date
    06-23-2007
    Posts
    690
    bump bump bump

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1