Posts by numcrun

Re: Protect Forms toolbar buttons but not drawing toolbar Text box using VBA. USD $20

Thanks for that. I did it slightly differently:

Activesheet.Protect DrawingObjects:=True
        Activesheet.Shapes("Text Box 4").Locked = True
        Activesheet.Shapes("Text Box 4").ControlFormat.LockedText = False

The buttons are already locked.

Re: Protect Forms toolbar buttons but not drawing toolbar Text box using VBA. USD $20

I have paid you anyway but I don't need your code. Thanks.

Re: Protect Forms toolbar buttons but not drawing toolbar Text box using VBA. USD $20

I may have worked out how to do this. So please don't send me your code at this stage.

Re: Protect Forms toolbar buttons but not drawing toolbar Text box using VBA. USD $20

I have paid the 10% to ozgrid now.

Re: Protect Forms toolbar buttons but not drawing toolbar Text box using VBA. USD $20

I have updated my options so you should be able to PM me thanks.

I have Excel 2003. I have buttons from the Forms toolbar and a text box from the Drawing toolbar. I want to protect the buttons but not the text box using VBA.

Re: format cells that have been copied

This works for CTRL + C:

In ThisWorkbook module

Private Sub Workbook_Open()


Application.OnKey "^{C}", "test"
Application.OnKey "^{c}", "test"


End Sub

and in a code module

Sub test()
         
Selection.Font.ColorIndex = 7
     
End Sub

Re: Project window objects are all inline

Just found the answer, there are 3 icons at the top of the screen. Never used them in 11 years. The file uploader is not working BTW.

I have no idea how this happened. How do I restore them to be grouped? Please see attached screenshot. This is in Excel 2003.

Re: USD $20.00 Excel print word vba automation via paypal

Ignore sorry mistake

Re: Isnumeric give different results on different PCS

Yes that's it! Thanks a lot for clearing that up. Still seems odd though.

Re: Isnumeric give different results on different PCS

"Are the References (Tools > References) in the Visual Basic Editor (VBE) the same between the two machines?"

Good question, but I just checked and the references are exactly the same. Don't worry too much about it, I can easily work around it. Just an oddity which caused a user to get an error message which has not occurred in the last 9 years of use on various MS Office/Windows combinations.

Re: Isnumeric give different results on different PCS

"What does "$5" + 2 return on those two machines?"

I get 7 on the true machine and a type mismatch 13 on the other. I have had several PCs of various OSes and Excel versions, all return true except this new PC I just set up. It has a new ASRock motherboard, an SSD, and Windows XP home.

I have 2 PCs, both running Excel Small Business Edition 2003 SP3 with the same version number. Both run Windows XP Version 2002 with SP3. Yet on one Isnumeric("$5") is false, and on the other it is true. Sometimes Excel drives me crazy. Why is this happening?

Re: USD $20.00 Excel print word vba automation via paypal

I am quite happy to pay you $10 if you give me your paypal, for the work you have done. There were a few things in your code I had not seen before which were interesting.

I have changed the code so there is always at least one word doc kept open, if this works I will be satisfied as 99.9% of the time there is another doc associated with the project open anyway.

Re: USD $20.00 Excel print word vba automation via paypal

What I am going to try is to close the document to be printed if another document is open. This would be a satisfactory solution as there is normally another document open in this project. Not sure if Excel requires the document to be printed to be open or just a Word window though.

Re: USD $20.00 Excel print word vba automation via paypal

The problem occurred again yesterday, here's what actually happens, in the case where the document to be printed is the only one opened:

- Excel says "Excel is waiting for an OLE object......", and when you click OK it pops up again.
- There are no word documents open, but WINWORD.EXE is still running.
- Killing WINWORD.EXE is the only way to stop the Excel dialog box.
- The document does not print.

Since the code has got to the point where the document has been closed, I assume that Application.BackgroundPrintingStatus has been set to 0 even though the document has not printed. The document has then been closed even though Excel is still waiting for some kind of signal from it. The only answer I can see is to leave the document open which is not great but I'm not sure what else I can do. I cannot see that your revised code addresses this issue. Give me your paypal and I'll give you $10, and another $20 if you can solve this problem.

Thanks
Matt

Re: USD $20.00 Excel print word vba automation via paypal

I guess you may need the class module sub, if printing takes a while and the Word doc is activated so I will leave it in.

Re: USD $20.00 Excel print word vba automation via paypal

I meant class module sub, not the whole thing.

Re: USD $20.00 Excel print word vba automation via paypal

Yes that's better. Also need blnNewWord = False at the start otherwise when it is True it persists in memory for the next run, and closes all docs. The class module doesn't seem necessary now that the user can't close the word document by mistake. I will test this over the next few weeks plus and see - it is a very occasional problem. Thanks for your help, will get back to you.