Excel CheckBox - Enabled "False" but I don't want it grayed out

Visual Basic for Applications (VBA)

‹ Microsoft ISV
- Archive
  - VS Express
  - Game
  - Windows Vista
  - ISV
  - VS 2008
  - VB
  - VFP
  - SharePoint
  - Dotnet
  - Windows Forms
  - Architecture
  - Office
  - Smart Device
  - IE
  - VC++
  - Windows Live
  - Visual Studio
  - SQL Server
  - Visual C#

- Previous
  - 1
    - activate a sheet containing a specific chrtobject Hi, You would need to activate the parent parent of the chartobject. aCH.Parent.Parent.Activate Tag: Excel CheckBox - Enabled "False" but I don't want it grayed out
  - 2
    - Overflow (error 6) It may not be the obvious and nothing to do with the Double data type. It could be an error within the expression itself. For example, the date functions (Year, Month etc) return NULL if the time argument is NULL, which obviously can't happen if you're passing Now(), but it's got to be something along those lines. Perhaps have each component part of that expression write to the debug window so if the error happens again, you can see what the individual components are equating to. Tag: Excel CheckBox - Enabled "False" but I don't want it grayed out
  - 3
    - Adding Outlook signature using OLE automation. I have the same problem and did not found a solution yet. Searching MSDN brought up nothing. About your second point: I don't use the mehtods GetNamespace and GetDefaulfolder: Create OLE-objects O_Outlook, O_MailItem and O_Attachment O_MailItem = O_Outlook.CreateItem O_MailItem.To = H_Recipient O_MailItem.HTMLBody = H_Text O_MailItem.Save Tag: Excel CheckBox - Enabled "False" but I don't want it grayed out
  - 4
    - Once copied, can we export as a GIF file? I assume you're talking about simply taking a screenshot of the viewable range of the MS Excel document for insertion into a MS Word document. Do you need to do this programatically If not, just hit PrtScr on your keyboard, paste it into MS Paint, save it, and insert it into the Word document. If you need to do this in a program, you've got two obstacles to overcome as I see it: 1.) VBA doesn't provide a "native" method for taking screenshots (as far as I know). I believe you'll need to access the API to do this. If this does turn out to be the case, I can help you out with code. 2.) VBA has no support for converting bitmap images (which is the format your screenshot would be in) into .JPG or .GIF files. You'd need to use external libraries. If you can provide a bit more information on what you need to do and why, I can give you much more specific advice on how to solve the problem. Tag: Excel CheckBox - Enabled "False" but I don't want it grayed out
  - 5
    - help required related LCS(Live Communication Server). Hi, Your best bet for an answer to this question is to post to one of the LCS newsgroups. This page is an excellent resource for Live Communications Server 2005: http://www.microsoft.com/technet/community/newsgroups/server/livecomm.mspx Here you'll find links to a general LCS newsgroup and a developer newsgroup, both of which have a number of LCS experts available to assist. They will likely be the best bet for a detailed answer. :-) -brenda (ISV Buddy Team) Tag: Excel CheckBox - Enabled "False" but I don't want it grayed out
  - 6
    - this problem is also troubling me now!! :( >> Is it possible to connect to a SharePoint site and retrieve a document from a machine where the SharePoint is not installed by using the SharePoint object model It looks like it's not possible. I need to do a similar thing (connect via OM on Sharepoint from a machine where Sharepoint is not installed) and after my researchs, it appears that it's not possible: you need to use the Web Services. HTH Bye Tag: Excel CheckBox - Enabled "False" but I don't want it grayed out
  - 7
    - Internet Explorer 7 jpeg and gif blurry after tools/internet options/advance/reset You might try checking the zoom level you have set in the bottom right of the status bar of IE. See if setting to 100% fixes the issue. -brenda (ISV Buddy Team) Tag: Excel CheckBox - Enabled "False" but I don't want it grayed out
  - 8
    - WMI.Net 2.0 As far as I know there's no beta program yet. There's a web cast on the technology available here: http://www.microsoft.com/events/webcasts/library/200606.mspx At the end of the session, the Program Manager announces that the plan (at time of the presentation) was: start a beta program after they are done with Vista (which was completed just a couple of weeks ago) ship WMI 2.0 as part of next version of .NET Framework (code named "Orcas" (watch this space for "Orcas" info and downloads: http://msdn2.microsoft.com/en-us/vstudio/aa700830.aspx ) -Michel Tag: Excel CheckBox - Enabled "False" but I don't want it grayed out
  - 9
    - Word document Hi Friends I have two word documents.I have to compare the both documents.The difference between the two document is that the second documents contains an image,insert some data or delete some existing data.I am able to find the changes and store the result in another document in which the changes reflects.Now our main moto is how can the end user identify that there is a change of only image in both the documents without opening the word file. Thank & Regards Tag: Excel CheckBox - Enabled "False" but I don't want it grayed out
  - 10
    - iexplore.exe - Application Error I get the exact same message. Have you found any answers What have you tried to do Tom Tag: Excel CheckBox - Enabled "False" but I don't want it grayed out
  - 11
    - How do I deal with files of more than 65k rows? Well, you need to read the file yourself. And then populate each cell into multiple sheets. Or You can split up the csv file into multiple csv files and open them using Excel csv reader. I personally prefer the first approach because I need to put ' in front of zip code or zero leading IDs. Tag: Excel CheckBox - Enabled "False" but I don't want it grayed out
  - 12
    - Using VBA macro to locate next free column on worksheet Try this to validate a column is empty or not. I know that I can make this more compact, but I can kind of too lazy, hehe. The Find function is basically a general driver for the same Find function in VBA, but take cares of error massage, and return boolean of found or not found. The Find_inOneColumn is self explaintory, general for all value. And the ColumnIsEmpty is the special case you want. You may want to think about treating a cell contains " " (spaces) is empty or not. Function ColumnIsEmpty() As Boolean ColumnIsEmpty= Not Find_inOneColumn("*") End Function Function Find_inOneColumn(vWhat As String, Optional vAfter As Range, _ Optional vLookInFormulas As Boolean = True, Optional vByPart As Boolean = True, _ Optional vMatchCase As Boolean = False, Optional vSearchFormat As Boolean = False) As Boolean If IsNull(vAfter) Then Set vAfter = Range("A1") Dim CurrentCol As Long CurrentCol = vAfter.Column If Find(vWhat, vAfter, vLookInFormulas, vByPart, False, vMatchCase, vSearchFormat) Then If CurrentCol = ActiveCell.Column Then Find_inOneColumn = True Else Find_inOneColumn = False End If Else Find_inOneColumn = False End If End Function Function Find(vWhat As String, Optional vAfter As Range, _ Optional vLookInFormulas As Boolean = True, _ Optional vByPart As Boolean = True, Optional vByRows As Boolean = True, _ Optional vMatchCase As Boolean = False, Optional vSearchFormat As Boolean = False) As Boolean If IsNull(vAfter) Then Set vAfter = Range("A1") vAfter.Select Dim vLookInFormulas2, vByPart2, vByRows2 If vLookInFormulas Then vLookInFormulas2 = xlFormulas Else vLookInFormulas2 = xlValues End If If vByPart Then vByPart2 = xlPart Else vByPart2 = xlWhole End If If vByRows Then vByRows2 = xlByRows Else vByRows2 = xlByColumns End If On Error GoTo FindByRow_Error_Handle Cells.Find(What:=vWhat, After:=ActiveCell, LookIn:=vLookInFormulas2, _ LookAt:=vByPart2, SearchOrder:=vByRows2, SearchDirection:=xlNext, _ MatchCase:=vMatchCase).Activate 'MatchCase:=vMatchCase, SearchFormat:=vSearchFormat).Activate Find = True Exit Function FindByRow_Error_Handle: Find = False End Function Tag: Excel CheckBox - Enabled "False" but I don't want it grayed out
  - 13
    - Setting a Bookmark to insert a Page Break in MS Word Is this what you wanted Code Snippet Sub Insert_BKMK_PageBk() Selection.Bookmarks.Add "MyBookMark" Selection.InsertBreak End Sub Cheers Shasur Tag: Excel CheckBox - Enabled "False" but I don't want it grayed out
  - 14
    - Macro - Replacing Contents of Cells Here is a simple sub that does that for you Code Snippet Sub Replace_For_Rachel() Dim rGCol As Range Dim sB2Text As String Set rGCol = Range("G2:G" & CStr(Range("G:G").Cells.SpecialCells(xlCellTypeLastCell).Row)) sB2Text = Range("B2").Value For Each gcell In rGCol If gcell.Value = sB2Text Then gcell.Value = 1 Else gcell.Value = 0 End If Next gcell End Sub Cheers Shasur Tag: Excel CheckBox - Enabled "False" but I don't want it grayed out
  - 15
    - Getting data from other workbooks Hi Would it not be simpler to put a formula in cell B2 referencing the cells in the Slave sheets Tag: Excel CheckBox - Enabled "False" but I don't want it grayed out
  - 16
    - Run Time Error 9 when Calling a Userform Hi, Error 9 is a 'Subscript out of range'. so for example referencing a worksheet that does not exit will raise that error. MsgBox Worksheets("Sheet99").Name or trying to access an element of an array beyond the bounds of the array. Dim vArray(3) As Variant vArray(4) = 1 But without seeing any of your code it's pretty hard to guess exactly whats wrong. Tag: Excel CheckBox - Enabled "False" but I don't want it grayed out
- Next
  - 1
    - iexplore.exe - Application Error I get the exact same message. Have you found any answers What have you tried to do Tom Tag: Excel CheckBox - Enabled "False" but I don't want it grayed out
  - 2
    - Parse AIM Buddy List Export file and Import to LCS 2005 Client Did you every successfully get the script working to get the AOL buddy list into LCS Tag: Excel CheckBox - Enabled "False" but I don't want it grayed out
  - 3
    - How to make a macro to copy some parts of a table to an email that it will create? upz for today! Tag: Excel CheckBox - Enabled "False" but I don't want it grayed out
  - 4
    - Automatically send attachment in email with a submit command button in word What errors are you seeing Tag: Excel CheckBox - Enabled "False" but I don't want it grayed out
  - 5
    - Excel VBA Five files at once, or sequentially Here are some hints. GetOpenFileName has a multi-select argument which allows the user to select more than one file at a time. The files are returned as an array, so Filename should be declared as a Variant. Instead of FileNumber = 1 you should use FileNumber = FreeFile, in case there are any other files open. You could do something like this to open the files: Dim iFile as Long Dim FileNumber() As Long ReDim FileNumber(LBound(Filename) to UBound(Filename)) For iFile = LBound(Filename) to UBound(Filename) FileNumber(iFile) = FreeFile Open Filename(iFile) For Input As #FileNumber(iFile) Next Now all the files are open, do your stuff, then close them. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ Tag: Excel CheckBox - Enabled "False" but I don't want it grayed out
  - 6
    - .mdmp files not being created David, on Vista, minidumps are transmitted only upon explicit demand from the server, at least that is how I understand it. Jason Hardester's post at http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1426737&SiteID=1 explains some of the rationale behind the server's decisions. You can force the system to always generate minidumps by enabling queuing mode: Set HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\Windows Error Reporting\ForceQueue (DWORD) to 1. Crash report data are stored in c:\Users\someusername\AppData\Local\temp and C:\ProgramData\Microsoft\Windows\WER\ReportQueue . Hope this helps, Claus http://www.clausbrod.de/Blog Tag: Excel CheckBox - Enabled "False" but I don't want it grayed out
  - 7
    - How do I accomplish this in VBA using Office 97 and later? I am trying to come up with a system that would improve efficiency in creating Request for Quote and Purchase Orders. As an example, here is what I am trying to do with the Request for Quote. 1.) A new document from a template called "Request for Quote" is created. 2.) The system asks for an Excel file to import that has bid item information in specific columns and from a set row down to the end. 3.) The system uses an Outlook address book to pull up a list of vendors. You can then select a checkbox control next to each vendor to include the vendor. Vendors are displayed one by one from top to bottom. 4.) The same thing done in step 3 is performed for the bid items using the Excel file imported earlier. 5.) The information is appropriately placed in the template. I can apply the Request for Quote concepts to Purchase Orders. Any idea on the most efficient way to accomplish this type of system Tag: Excel CheckBox - Enabled "False" but I don't want it grayed out
  - 8
    - ASP .NET 1.1 fails at install, but not .NET Framework 1.1 I found the solution, actually: when installing the Applications, under Add/Remove Programs, Add/Remove Windows Components, I didn't select the Details button and the ASP. This is on the Server 2003 Ent. OS. Tag: Excel CheckBox - Enabled "False" but I don't want it grayed out
  - 9
    - How to allow cookies for Windows Live ID Hi Ralph, Can you please provide some details on this issue and your computing environment thanks, -brenda (ISV Buddy Team) Tag: Excel CheckBox - Enabled "False" but I don't want it grayed out
  - 10
    - Projects, objects & modules Hi, Project contains all the classes related to the document. ThisDocument is a special class referencing the document within the project. The events of the document are exposed in the Thisdocument object. Modules contain code which is available to the whole project, taking into account any scope issues. Multiple modules tend to be used on more complex projects. Recording macros in a freshly opened copy will cause the code to be placed in a new module. Keeps new code away from any previously created and structured coding. How are you learning VBA This site might be of interest. http://word.mvps.org/FAQs/MacrosVBA/index.htm Tag: Excel CheckBox - Enabled "False" but I don't want it grayed out
  - 11
    - A macro to count the number of macros in a woorkbook Hi here is the crude code to get the procedures from a workbook Code Snippet Sub Count_Program() Dim VBP As VBProject Dim VBModule As CodeModule Dim VBProc As VBComponent Dim sLastProcName As String Set VBP = ThisWorkbook.VBProject For Each VBM In VBP.VBComponents Set VBModule = VBM.CodeModule i = 1 Do Until i >= VBModule.CountOfLines procname = VBModule.ProcOfLine(i, vbext_pk_Proc) i = i + 1 If LenB(procname) <> 0 Then If procname <> sLastProcName Then MsgBox procname sLastProcName = procname End If End If Loop 'MsgBox VBModule.Name & vbCrLf & VBModule.CodeModule.CountOfDeclarationLines Next End Sub You need to add the Visual Basic for Extensibility reference in the References. Please fine tune it to loop through open workbooks Cheers Shasur Tag: Excel CheckBox - Enabled "False" but I don't want it grayed out
  - 12
    - ComboBox listing on Startup Hi, You need to set either the value or listindex. So to set the combobox to Open App3 either of these will do. ComboBox1.Value = "Open App3" or ComboBox1.Listindex = 2 Tag: Excel CheckBox - Enabled "False" but I don't want it grayed out
  - 13
    - PASSING MS OUTLOOK DATA TO EXCEL Hi, This will pull calander information from Outlook into the activesheet in excel. Remember to include a reference to the Outlook library. Within VBE use Tools > References. Sub GetOLCalander() ' ' requires reference to Outlook Library ' Dim olApp As Outlook.Application Dim objNameSpace As Outlook.Namespace Dim olItem As Outlook.AppointmentItem Dim lngRow As Long Set olApp = CreateObject("Outlook.Application") Set objNameSpace = olApp.GetNamespace("MAPI") ActiveSheet.Range("A1:C1") = Array("Subject", "Start", "Finish") lngRow = 2 For Each olItem In objNameSpace.GetDefaultFolder(olFolderCalendar).Items With ActiveSheet .Cells(lngRow, 1).Value = olItem.Subject .Cells(lngRow, 2).Value = olItem.Start .Cells(lngRow, 3).Value = olItem.End End With lngRow = lngRow + 1 Next Set objNameSpace = Nothing Set olApp = Nothing End Sub Tag: Excel CheckBox - Enabled "False" but I don't want it grayed out
  - 14
    - MDI on old Office but not on new Office 2007? This topic has had a great deal of discussion on the forum. Here's a link to another thread that has steps to reinstall MODI: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=962616&SiteID=1 thanks, -brenda (ISV Buddy Team) Tag: Excel CheckBox - Enabled "False" but I don't want it grayed out
  - 15
    - referenced memory error hello people. can someone help me. My computer displays an error saying instruction at "0x269e7875" refernced memory at "0x269e7875". The memory could not be "read". Click ok to terminate the program. And I cannot switch from one user to another. I can log-off from windows and switch user. It needs to be restarted every time I want to switch from one user to another. Tag: Excel CheckBox - Enabled "False" but I don't want it grayed out
  - 16
    - Visual Basic Code Corrupted? Hi, Welcome to MSDN Visual Basic Language Forum,This forum supports Visual Basic.NET (7, 7.1, 8, ...) issues only, so, your question is an off-topic here and this isn't the best place to ask it, to get an answer about your question , please visit Visual Basic for Applications web site: http://forums.microsoft.com/MSDN/ShowForum.aspx ForumID=74&SiteID=1 Good luck Tag: Excel CheckBox - Enabled "False" but I don't want it grayed out

suznal

Is there a way with VBA to have a CheckBox with the enabled property set to false but defeat the "grayed out" quality.

I have checkboxes that take their value from other objects and I do not want the users to be able to select them, but I don't want them to look grayed out either.

Re: Excel CheckBox - Enabled "False" but I don't want it grayed out

Andy Pope

Hi,

Set the Locked property to TRUE.
You can change the value with code but not by clicking.

Re: Excel CheckBox - Enabled "False" but I don't want it grayed out

suznal

Setting the locked property to True did not do it, (all of mine are true by default anyway).

The only thing I have found useful with that property is that when the sheet is protected users cannot move the checkbox or access the properties (must unprotect the sheet first).

Re: Excel CheckBox - Enabled "False" but I don't want it grayed out

Andy Pope

The Locked property will only work if the control is on a userform.

Re: Excel CheckBox - Enabled "False" but I don't want it grayed out

suznal

These checkboxes are on worksheets...

Re: Excel CheckBox - Enabled "False" but I don't want it grayed out

suznal

I take it that it is not possible to acheive this

Re: Excel CheckBox - Enabled "False" but I don't want it grayed out

Andy Pope

Not that I know of.
You have to use sheet protection and the locked property.