Check boxes are unchecked in Listbox that were checked off before. How can I stop this?

Rochelle711

New Member
Joined
Jun 22, 2014
Messages
1
[h=1]Hello everyone! Hopefully you can help me with this and I'm just missing something really simple :p

I'm having an issue with a worksheet I have pasted into a PowerPoint slide using Paste Special>Paste Link>Microsoft Excel Worksheet (code) Object.

The trouble is in the worksheet I have a ActiveX Listbox with check boxes in it.

Whenever I test it like this:
I open the sheet by double clicking on the object pasted into PPT.
In the popup XLSM sheet I check some of the boxes to indicate what tasks have been completed.
I save and close the popup XLSM sheet and "update link" on the object pasted into PPT.

However whenever I go back into the XLSM sheet again by double clicking on the object all the check boxes are unchecked again.

How can I make this not happen so that I don't lose all the checked boxes every time I open the sheet? I have 100s of tasks with check boxes and it is not efficient to have to recheck all of the ones previously checked off every time I want to check off a new task.

Thank you for any help or suggestions you can provide!! :confused:

(Ps I use Office 2010)[/h]
 

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type

Forum statistics

Threads
1,213,536
Messages
6,114,207
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top