My Online Training Hub

Learn Dashboards, Excel, Power BI, Power Query, Power Pivot

Disable right-click on slicers in Excel|VBA & Macros|Excel Forum|My Online Training Hub

You are here: Home / Disable right-click on slicers in Excel|VBA & Macros|Excel Forum|My Online Training Hub

vba course banner

Avatar
sp_LogInOut Log In sp_Registration Register
sp_Search Search
Advanced Search
Search
Forum Scope



Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
sp_Search Search
sp_RankInfo
Lost password?
sp_PrintTopic sp_TopicIcon
Disable right-click on slicers in Excel
Avatar
Greg Malek

Active Member
Members
Level 0
Forum Posts: 3
Member Since:
March 19, 2021
sp_UserOfflineSmall Offline
1
March 21, 2021 - 7:56 am
sp_Permalink sp_Print

Dear All

Is there any way to disable the right-click on slicers in Excel.

I have managed to lock or/and disable most of the Excel functionality on my dashboard but, the slicers are still accessible from the right-click.

Any direction would be appreciated.

Regards,

Avatar
Catalin Bombea
Iasi, Romania
Admin
Level 10
Forum Posts: 1826
Member Since:
November 8, 2013
sp_UserOfflineSmall Offline
2
March 21, 2021 - 3:29 pm
sp_Permalink sp_Print

Short answer: No.

There are no events associated to slicers that can detect if a user right clicked on a slicer.

Avatar
vasim khatik
Member
Members
Level 0
Forum Posts: 26
Member Since:
July 15, 2018
sp_UserOfflineSmall Offline
3
March 21, 2021 - 5:07 pm
sp_Permalink sp_Print

1) First insert the shape (rectangle) then move to slicer this shape 

2) Group the together and name the Group

3) then write the code worksheet event

Like

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
Sheet1.Shapes.Range(Array("JobGrp")).Visible = msoTrue
End Sub

Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As Boolean)
Sheet1.Shapes.Range(Array("JobGrp")).Visible = msoFalse
End Sub

Avatar
Velouria
London or thereabouts
Moderator
Members


Trusted Members

Moderators
Level 4
Forum Posts: 649
Member Since:
November 1, 2018
sp_UserOfflineSmall Offline
4
March 22, 2021 - 7:47 am
sp_Permalink sp_Print

What exactly are you trying to prevent?

Avatar
vasim khatik
Member
Members
Level 0
Forum Posts: 26
Member Since:
July 15, 2018
sp_UserOfflineSmall Offline
5
March 22, 2021 - 2:27 pm
sp_Permalink sp_Print

YES see the the sheet1 Double Click Show the slicer and right click hide

Avatar
Emad Nessiem

New Member
Members
Level 0
Forum Posts: 1
Member Since:
August 4, 2021
sp_UserOfflineSmall Offline
6
August 4, 2021 - 4:57 am
sp_Permalink sp_Print

Hi gents,

I am not sure what this code is doing, once I right claik on a cell the slicer disappears.

You know, I am keeping looking for a solution for the same subject made by @ Greg Malek.

 

I am looking for a way or a code to disable the slicer right-click when I protect a sheet.

 

I have the code to disable the cells right-click, but the Slicer even after protecting the sheet is still allowing for right-click and then unwanted changes.

 

If I locked the slicer from the size and properties, then no filtering!

 

Please help me to solve this issue

sp_Feed
Go to top
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Louis Muti
Guest(s) 8
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 873
Purfleet: 414
Frans Visser: 346
David_Ng: 306
lea cohen: 222
Jessica Stewart: 218
A.Maurizio: 202
Aye Mu: 201
jaryszek: 183
Newest Members:
Blair Gallagher
Brandi Taylor
Hafiz Ihsan Qadir
Gontran Bage
adolfo casanova
Annestine Johnpulle
Priscila Campbell
Jeff Mikles
Aaron Butler
Maurice Petterlin
Forum Stats:
Groups: 3
Forums: 24
Topics: 6369
Posts: 27852

 

Member Stats:
Guest Posters: 49
Members: 32359
Moderators: 3
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: MOTH Support, Velouria, Riny van Eekelen