Pen In Microsoft Excel is inactive

BittenApple
BronzeLounger
Posts: 1223
Joined: 01 Mar 2015, 02:03

Pen In Microsoft Excel is inactive

Post by BittenApple »

Hello team,
I go to Excel Options -> Customize Ribbon -> All Commands and add Pen and Select Object to Main Tab:

They are placed there but they are inactive. What should I do to make them active?

Purpose: I want to be able to draw lines with a pen on Ribbon :scratch: :scratch: :scratch: .

Respectfully,
BittenApple

User avatar
HansV
Administrator
Posts: 67238
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Pen In Microsoft Excel is inactive

Post by HansV »

Do you have a touch screen and a pen connected to your computer?
Regards,
Hans

BittenApple
BronzeLounger
Posts: 1223
Joined: 01 Mar 2015, 02:03

Re: Pen In Microsoft Excel is inactive

Post by BittenApple »

Hello Hans,

Thanks for the response.
I do have a touch screen but I don't know if a pen is connected to my computer.

Regards,
BittenApple

User avatar
HansV
Administrator
Posts: 67238
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Pen In Microsoft Excel is inactive

Post by HansV »

If there was a pen, you'd see it...
Regards,
Hans

BittenApple
BronzeLounger
Posts: 1223
Joined: 01 Mar 2015, 02:03

Re: Pen In Microsoft Excel is inactive

Post by BittenApple »

Hello Hans,
Thanks for the response.
No pen is attached to my computer.
Regards,
BittenApple

User avatar
HansV
Administrator
Posts: 67238
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Pen In Microsoft Excel is inactive

Post by HansV »

I think that explains why the Pen button is disabled...
Regards,
Hans

BittenApple
BronzeLounger
Posts: 1223
Joined: 01 Mar 2015, 02:03

Re: Pen In Microsoft Excel is inactive

Post by BittenApple »

Hans,
I thought that pen which is in all commands is like a pen in snipping tool. it is like a soft pen.
Please advise me.
Regards,
BittenApple

User avatar
HansV
Administrator
Posts: 67238
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Pen In Microsoft Excel is inactive

Post by HansV »

I don't have a touchscreen myself, so I don't know for sure, sorry.
Regards,
Hans

BittenApple
BronzeLounger
Posts: 1223
Joined: 01 Mar 2015, 02:03

Re: Pen In Microsoft Excel is inactive

Post by BittenApple »

Hans,
Thanks for response!
BittenApple

User avatar
StuartR
Administrator
Posts: 10631
Joined: 16 Jan 2010, 15:49
Location: London, Europe

Re: Pen In Microsoft Excel is inactive

Post by StuartR »

I have a PC with a touch screen, but no physical pen.

I can select "Draw with touch" from the Draw menu and then draw on the screen with my finger
You do not have the required permissions to view the files attached to this post.
StuartR


BittenApple
BronzeLounger
Posts: 1223
Joined: 01 Mar 2015, 02:03

Re: Pen In Microsoft Excel is inactive

Post by BittenApple »

Hello StuartR,
Thanks for the response!

I don't have Draw tab on my Excel. I think you added as a Custom tab, don't you?
But under review tab, there is Start Inking option that anything can be drawn on the sheet by using that option. Additionally, the pen and select object that I added from options -> All Commands ->to my Excel workbook, now it is active. I don't know how this happened.

I wonder what gives me the ability to draw lines on the items on the ribbon because with these I can draw lines on the spreadsheet itself only.

Respectfully,
BittenApple

User avatar
StuartR
Administrator
Posts: 10631
Joined: 16 Jan 2010, 15:49
Location: London, Europe

Re: Pen In Microsoft Excel is inactive

Post by StuartR »

I did not intentionally add the Draw tab, but I have just checked and it is visible as soon as I start Excel.

I can't imagine any Excel tool that would let you draw on the ribbon, what problem are you trying to solve?
StuartR


BittenApple
BronzeLounger
Posts: 1223
Joined: 01 Mar 2015, 02:03

Re: Pen In Microsoft Excel is inactive

Post by BittenApple »

Hello StuartR,

I have Microsoft 2013; when I start Excel, I don't have a draw tab. Anyway, I got what I was looking for, as none of these tools can draw a line on the Ribbon.

I wanted to point out to something on the ribbon and send it to someone. I can use snipping tool.

Regards,
BittenApple

User avatar
HansV
Administrator
Posts: 67238
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Pen In Microsoft Excel is inactive

Post by HansV »

Yes, you do need something like the Snipping Tool or a graphics program for that. The drawing tools in Excel itself are only for drawing on the spreadsheet.
Regards,
Hans

BittenApple
BronzeLounger
Posts: 1223
Joined: 01 Mar 2015, 02:03

Re: Pen In Microsoft Excel is inactive

Post by BittenApple »

Thanks for clarification.
BittenApple :thankyou: :thankyou: :thankyou: :thankyou: :thankyou: