+ Reply to Thread
Results 1 to 2 of 2

Macro to populate cell and then lock it

  1. #1
    Registered User
    Join Date
    08-02-2013
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    1

    Macro to populate cell and then lock it

    Hi All

    I have a macro which works fine in Excel 2003. It's quite a simple one where I just populate a cell with a ZERO depending on what has been selected from a dropdown menu, and then lock the cell. Here's the code:

    Please Login or Register  to view this content.
    However, when I open my file in Excel 2010, and try the macro, Excel just crashes.

    Would anyone have any ideas as to why it crashes in Excel 2010, am I missing some code?

    Thanks in advance
    Simon
    Last edited by JBeaucaire; 08-03-2013 at 04:30 AM. Reason: Added CODE tags, as per Forum Rules. Take a moment to read the Forum Rules in the menu bar above. Thanks.

  2. #2
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Macro to populate cell and then lock it

    How about this instead:

    Please Login or Register  to view this content.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

+ 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. [SOLVED] Lock cell(s) after data input using macro.
    By kawaitang in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-28-2013, 02:44 PM
  2. Populate cell with current date and time, then lock cell
    By panny in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-17-2012, 06:13 PM
  3. [SOLVED] Help with code to lock cell range during Macro.
    By galvinpaddy in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-04-2012, 02:43 PM
  4. Macro to Paste Cell Range and Lock Cells
    By KeNz- in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-18-2012, 08:50 PM
  5. Macro to lock cells after a particular cell has been change
    By blankus in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-26-2010, 02:11 PM

Tags for this Thread

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