Search results for query: *

I am a first-time user AutoHotKey (AHK), trying to get it to give me a shortcut for a text string (my email address) that I have to enter very frequently in all sorts of contexts.[ ] The shortcut I wanted to use was Ctrl-Shift-R, and I expected this would be an easy task requiring only the...

My apologies in advance for posting this on what is probably the wrong forum, but it looked to me like the least inappropriate. I am a long-time regular user of both this Tek-Tips site and its companion site Eng-Tips.[ ] About 12 hours ago, after working fine only a few hours earlier, my...

Suppose I have a very simple (and entirely hypothetical) structured table in Excel containing data about people.[ ] Its columns might be:[ ] Name, DateOfBirth, Salary, Department. Outside the table, above it and aligned with the appropriate table columns, I have cells containing...

A few days ago, and for no obvious reason, my computer ceased allowing me to click on a hyperlink in an email and have that link automatically opened in my default browser.[ ] Instead I now get a message saying "This operation has been canceled [sic] due to restrictions in effect on this...

This is a repeat of a post I put on Eng-Tips about a fortnight ago.[ ] See https://www.eng-tips.com/viewthread.cfm?qid=493208 for that post and the replies it elicited.[ ][ ] It looks like I will not be able to achieve my aim in this matter, but I thought it worth trying this...

I believe there is an Excel function called FORMULATEXT(CellAddress), which was introduced as part of Excel 365.[ ] You feed it the address of a cell that contains a formula, and it returns you the text of the formula, rather than the formula's value as displayed in the cell. I am seeking...

I run Excel 2010.[ ] I have just noticed that in some of the VBA code I have developed over the last ten years I have used [ ][ ][ ][ ][ ]Application.Calculation = xlCalculationManual while elsewhere I have used...

Does anyone know how to use Excel's VBA to determine how a workbook was opened by its user?[ ] I need to know whether my remote user opened his workbook by double-clicking upon the workbook file in File Explorer, or by first firing up Excel and then using its File>Open menu item. (Please...

For client-dictated reasons I need to prevent the users of the spreadsheet I am developing from using certain printers under certain circumstances.[ ] Obviously this requires the use of the Workbook_BeforePrint event handler. How, inside that event handler, do I determine the destination...

Every so often I come across articles that talk about how making heaps of modifications to VBA[ ]code in Excel spreadsheets can lead to a build-up of "rubbish" in the code, and how that rubbish can eventually lead to execution problems.[ ] The solution, apparently, is to "clean" your...

I am having some difficulties with what I think is called the "scope" of VBA subroutines in cases where these subroutines are invoked via a "Ctrl-x" style shortcut. This arises in a workbook I developed for a client.[ ] I never envisaged that the client's staff might have two of the...

I have just discovered some "inconsistent" behaviour between Excel's spreadsheet environment and its VBA environment.[&nbsp;] It involves the sort order of characters.[&nbsp;] In the spreadsheet, it is TRUE that ("_"<"X"), whereas in VBA it is FALSE.[&nbsp;] This anomaly tripped me up because...

I am developing a multi-sheet workbook for a building-industry client who wants to achieve limited "project management" capabilities entirely within Excel (Excel[&nbsp;]2010).[&nbsp;] Several of the worksheets have a top part that presents tabulated numerical and non-numerical data, the...

For several days I have been trying to access the VBA Search Engine that is (was?) provided by J P Software Technology, at URL http://www.jpsoftwaretech.com/vba-search-engine/ I keep getting a "webpage cannot be found" error.[&nbsp;] If I attempt to access http://www.jpsoftwaretech.com I get a...

I have a complex spreadsheet that makes extensive use of VBA, including Command Buttons and Event Handlers. I have developed it over quite a few years, and therefore quite a few versions of Excel, but only ever on Windows versions of Excel. It is able to be run on all Excel versions from 97 to...

Over the years I have developed a few Excel spreadsheets that are intended to be used by engineers of vastly differing Excel skill levels. Several of these spreadsheets use Excel's Solver, and to make them as bullet-proof as possible I have used VBA to automate the Solver. I am in the process...