Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-22-2014, 06:16 PM
Rochelle711 Rochelle711 is offline Checkboxes are unchecked in Listbox that were checked off before.How can I stop this? Windows Vista Checkboxes are unchecked in Listbox that were checked off before.How can I stop this? Office 2010 32bit
Novice
Checkboxes are unchecked in Listbox that were checked off before.How can I stop this?
 
Join Date: Jun 2014
Posts: 1
Rochelle711 is on a distinguished road
Question Checkboxes are unchecked in Listbox that were checked off before.How can I stop this?

Hello everyone! Hopefully you can help me with this and I'm just missing something really simple

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!!

(Ps I use Office 2010)
Reply With Quote
Reply

Tags
activex control, check box, listbox

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Delete Unchecked Multiple Choice Answers deboer Word VBA 4 05-06-2014 09:54 AM
how to show total of check boxes checked worder Word 16 03-10-2014 05:07 PM
Checkboxes are unchecked in Listbox that were checked off before.How can I stop this? Multi-select listbox help gvibe@hotmail.com Word VBA 1 07-19-2013 10:54 AM
Checkboxes are unchecked in Listbox that were checked off before.How can I stop this? Repeat Spell check in a doc that has already been checked mawigfie Word 1 08-22-2012 01:16 PM
Create makro that counts the number of checked tick boxes in a survey johannapaj Word VBA 0 09-05-2011 01:51 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:43 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft