+ Reply to Thread
Results 1 to 4 of 4

Protect sheets in my purchase order spreadsheet

Hybrid View

  1. #1
    Registered User
    Join Date
    05-07-2014
    Location
    Auckland
    MS-Off Ver
    Excel 2010
    Posts
    3

    Protect sheets in my purchase order spreadsheet

    Hi

    I am at beginner's level with macro's and vba etc. I managed to download a purchase order excel spreadsheet where by clicking on a New PO button a new worksheet would be created with new purchase order number. For eg a branch name is ABC so the purchase order will be ABC 00001, ABC 00002, ABC 00003 etc.

    What I need help with is to be able to protect the purchase orders created so no one can make changes once they are submitted except the owner. That is no one can change ABC 00001, ABC 00002 ABC 00003 etc. Also I want excel to automatically protect all the new sheets that will be created. Obviously not protect the template as that is where the purchase order details will be filled.

    Thanks
    Irshad

  2. #2
    Valued Forum Contributor Naveed Raza's Avatar
    Join Date
    11-04-2012
    Location
    India, Hyderabad
    MS-Off Ver
    Excel, Access 2007/2010
    Posts
    1,338

    Re: Protect sheets in my purchase order spreadsheet

    Would be great if you provide sample workbook with respective cells means which which cells you want to protect.
    Thanks - Naveed
    -----------------------------
    If the suggestion helps you, then Click * to Add Reputation
    To Attach File: Go Advanced>>Manage Attachments>>Add Files (In Top Right Corner)>>SelectFiles>>.........Locate Your File(s)>>Upload Files>>Done (In Bottom Right)
    1. Use [code] code tags [\code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.
    2. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.

  3. #3
    Registered User
    Join Date
    05-07-2014
    Location
    Auckland
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Protect sheets in my purchase order spreadsheet

    Thanks. File attached now.
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    05-07-2014
    Location
    Auckland
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Protect sheets in my purchase order spreadsheet

    ohh nooo looks like I wont have a solution here. Please
    anyone help me.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Need to create a purchase order from spreadsheet info
    By mjtb007 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-19-2013, 04:46 PM
  2. Order entry and Purchase Order using VBA
    By Rocky2013 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-08-2012, 12:39 AM
  3. Macro Reqd to update Purchase order log, everytime a new purchase order is made
    By manthankanabar in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-23-2012, 01:47 AM
  4. purchase order list & order number generator
    By podaf in forum Excel General
    Replies: 2
    Last Post: 06-28-2009, 06:02 PM
  5. [SOLVED] purchase order counter in excel purchase order template
    By Brandy@baoco in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-23-2005, 03:06 PM

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