Restrict button option to column "J" only

**caherine** · 07-13-2012, 03:43 PM

Please Login or Register  to view this content.

I need restrict this to Column "J" only. Is that possible? Thanks.

**biomix** · 07-13-2012, 03:57 PM

Hi caherine,

What I would suggest, as this is what I use, is:

Please Login or Register  to view this content.

Cheers,
-=Biomix

**xladept** · 07-13-2012, 03:57 PM

Hi Caherine,

Try this:

Please Login or Register  to view this content.

**caherine** · 07-13-2012, 04:01 PM

I am so new to VBA, you are helping me maintain my "worth" with my supervisors which, at anytime could consider me for the lay off. I want to cry. I've died and gone to excel heaven. I LOVE this place.

**xladept** · 07-13-2012, 07:57 PM

Glad to help!

**Cutter** · 07-13-2012, 08:59 PM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save