+ Reply to Thread
Results 1 to 4 of 4

UserInterFaceOnly and resize of table

  1. #1
    Registered User
    Join Date
    10-12-2014
    Location
    London
    MS-Off Ver
    2013
    Posts
    2

    UserInterFaceOnly and resize of table

    I'm using Excel 2013

    I want to know if it is possible to protect a worksheet and allow a user to resize a table using VBA.

    I have added the following code to the workbook open sub:

    Dim ws As Worksheet
    For Each ws In ThisWorkbook.Worksheets
    ws.Protect Password:="abc", UserInterFaceOnly:=True
    Next ws

    When the VBA to resize the table is called I get an error:

    "Cannot use this table functionality on a protected sheet"

    I was hoping that UserInterfaceOnly could be used as I don't want Unprotect the sheet, apply the table changes, then re-protect the sheet because of the slow performance of the Protect operation in Excel 2013

  2. #2
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    England
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,985

    Re: UserInterFaceOnly and resize of table

    Try changing this:
    Please Login or Register  to view this content.
    to this:
    Please Login or Register  to view this content.
    Everyone who confuses correlation and causation ends up dead.

  3. #3
    Registered User
    Join Date
    10-12-2014
    Location
    London
    MS-Off Ver
    2013
    Posts
    2

    Re: UserInterFaceOnly and resize of table

    Romperstomper - thanks for the reply. I tried the change you suggested and the table update does now work BUT the sheet now appears to be fully editable. As a user I can now enter data into any of the cells, delete add rows and columns etc. I was hoping that sheet edits through the user interface would be stopped

  4. #4
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    England
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,985

    Re: UserInterFaceOnly and resize of table

    Wow - that's weird and looks like a bug to me.

    I think you're out of luck then, I'm afraid - UIO doesn't work with everything.

+ 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] Resize table to same row count as a piovt table
    By djon5020 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-13-2014, 01:43 AM
  2. [SOLVED] VBA to resize a table based on a cell value
    By Vasool in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-24-2013, 06:10 PM
  3. Add row to end of table and resize table automatically
    By cdthimann in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-02-2013, 03:30 AM
  4. [SOLVED] Is it possible to resize a table and keep format & formulas?
    By NathanC in forum Excel General
    Replies: 1
    Last Post: 11-03-2012, 12:04 AM
  5. Can't Resize Table Rows in PowerPoint
    By daviddoria in forum Excel General
    Replies: 1
    Last Post: 09-06-2009, 09:31 AM

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