If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)

Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Excel Macro Problem

ArmCandyBaby · 2009-02-26 13:13:32

Hi, Does anybody know if there is a method to check whether a menu/command etc. has been greyed out or not? For instance, if 'paste special' is unavailable, I just want to use 'paste' instead, not get an error message. Cheers

26-02-2009 1:13pm

#1

ArmCandyBaby

Closed Accounts Posts: 201 ✭✭

Join Date: October 2008

Posts: 188

Hi,

Does anybody know if there is a method to check whether a menu/command etc. has been greyed out or not? For instance, if 'paste special' is unavailable, I just want to use 'paste' instead, not get an error message.

Cheers

0

Comments

#2 26-02-2009 2:24pm

FSL

Registered Users, Registered Users 2 Posts: 1,456 ✭✭✭

Join Date: February 2006

Posts: 1419

What version of Excel are you using. In Excel 2007 the Application.DisplayPasteOptions returns True if the paste button is on and false if the paste options button is off. The PasteSpecial method allows you to specify the type and the operation. Details and examples are in the Excel Help File. I would think the Help File in earlier versions would contain similar information.

0