Excel Forum

Table protection weirdness

Rod R

London, United Kingdom

Member

Members

Excel Expert

Power Query

Forum Posts: 6

Member Since:
July 14, 2022

Offline

July 14, 2022 - 11:23 pm

Hi everyone - first post!

I'm using Excel 365

If I protect my sheet, I cannot delete a row in a table by right-clicking in that table and selecting "delet row from table" - the delete option is greyed out. I've tried every option of access in the sheet protection submenu.

I don't really want to have to let users unprotect the sheet to delete a table row.

I've tried the VBA command to allow row deleting too - that doesn work either, I'm guessing it's something else for tables.

Does anyone have any ideas please?

Thanks in advance

Rod

Mynda Treacy

Admin

Forum Posts: 4449

Member Since:
July 16, 2010

Offline

July 15, 2022 - 12:21 pm

Hi Rod,

Welcome to our forum!

Tables do not allow editing when the sheet is protected. You need to write some VBA code that unprotects the sheet and allows the edit, then reprotects the sheet.

If you're stuck with that, please post your question and example file with your attempt in our VBA forum.

Mynda

Forum Timezone: Australia/Brisbane

Most Users Ever Online: 245

Currently Online: Richard West, Wesley Burchnall, Clayton Watson

Guest(s) 9

Currently Browsing this Page:
1 Guest(s)

Top Posters:

SunnyKow: 1432

Anders Sehlstedt: 871

Purfleet: 412

Frans Visser: 346

David_Ng: 306

lea cohen: 219

Jessica Stewart: 204

A.Maurizio: 202

Aye Mu: 201

jaryszek: 183

Newest Members:

Murat Hasanoglu

Brett Dryland

Saeed Aldousari

Bhuwan Devkota

Kathryn Patton

Maria Conatser

Jefferson Granemann

Glen Coulthard

Nikki Fox

Rachele Dickie

Forum Stats:

Groups: 3

Forums: 24

Topics: 6222

Posts: 27291

Member Stats:

Guest Posters: 49

Members: 31913

Moderators: 3

Admins: 4

Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT

Moderators: MOTH Support, Velouria, Riny van Eekelen