+ Reply to Thread
Results 1 to 3 of 3

Enable editing when workbook is opened

  1. #1
    Registered User
    Join Date
    08-09-2017
    Location
    Brisbane
    MS-Off Ver
    Office Home & Business 2016
    Posts
    21

    Enable editing when workbook is opened

    Hi,

    I have the below code in a workbook to open another workbook. I am trying to enable editing but I get the error in the screenshot on the last line of the code
    Please Login or Register  to view this content.
    Excel_vba enable editing.JPG

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,893

    Re: Enabl editing when workbook is opened

    Please show us all the code. When you get the error message and click on debug, which line of code is highlighted.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Registered User
    Join Date
    08-09-2017
    Location
    Brisbane
    MS-Off Ver
    Office Home & Business 2016
    Posts
    21

    Re: Enable editing when workbook is opened

    Please Login or Register  to view this content.
    Excel_vba enable editing2.JPG

+ 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. Replies: 3
    Last Post: 06-15-2017, 05:23 AM
  2. Disable editing when opened on other pc.
    By Fleur89 in forum Excel General
    Replies: 4
    Last Post: 01-15-2017, 08:25 PM
  3. Use a macro to extract cell data from opened workbook to new opened workbook
    By BrianTFC in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-26-2014, 01:35 PM
  4. ENABLE EDITING via VBA
    By jhanslip in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-07-2013, 06:15 PM
  5. enable editing
    By amartino44 in forum Excel General
    Replies: 2
    Last Post: 06-11-2013, 12:21 PM
  6. How to enable macros when a file is opened from another macro
    By aspicuelta in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-10-2011, 12:32 PM
  7. Excel 2007 : Enable Editing
    By ST31MY in forum Excel General
    Replies: 3
    Last Post: 02-18-2011, 05: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