ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How can I use Option Buttons independently in a mutli-tabed Excelf (https://www.excelbanter.com/excel-discussion-misc-queries/242786-how-can-i-use-option-buttons-independently-mutli-tabed-excelf.html)

Peter

How can I use Option Buttons independently in a mutli-tabed Excelf
 
Hi,
I summarize reports in 50+ sheets Excel file. All sheets contain Option
Buttons for answering a question. How can I make sure that these Options
Buttons work independently in all individual sheets?

Thanks & regards,
Peter

Dave Peterson

How can I use Option Buttons independently in a mutli-tabed Excelf
 
Are you asking how to make sure that the optionbuttons on one sheet are
independent from another?

If yes, make sure that any linked cells for the optionbuttons are not shared
between sheets.

But maybe I'm misunderstanding. Can you add more details.

Peter wrote:

Hi,
I summarize reports in 50+ sheets Excel file. All sheets contain Option
Buttons for answering a question. How can I make sure that these Options
Buttons work independently in all individual sheets?

Thanks & regards,
Peter


--

Dave Peterson


All times are GMT +1. The time now is 07:09 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com