I have just published a new pre-release of the new version of ASAP Utilities. It is ready for download and testing.
I have also experienced some crazy things with customizing the ribbon (qat) and empty Excel dialogboxes due to dynamic labels (getLabel). I will write more about that in a separate post.
- Fill » Random numbering of cells (without duplicates)
- ASAP Utilities Options » (Re) build the ASAP Utilities favorites menu toolbar
Create or update a toolbar with the buttons/tools from your favorites menu. The toolbar is automatically updated when you change your favorites menu or your shortcuts to the tools from ASAP Utilities
- Format » Copy a sheet's page and print settings...
Slightly improved speed. Furthermore it displays the current printer at the bottom. The speed of changing the page-setup in Excel might depend on the printer you currently have active. I will write more about this...
- Sheets » Freeze panes on multiple sheets at once
Improved. The wrong range was freezed when the selected range on the other sheet was not in the "visible area". This is now fixed
- System » Save file and create backup
Fixed the bug where in Excel 2007 the point was removed before the extention in the name of the backup. When the filename had an extension that was not 3 characters, for example xlsx in stead of xls it goes wrong. For example book1.xlsx became in the backup folder: Book1 (backup 2007-10-01 08.25.31)xlsx; no piont before xlsx.
Fixed a few small bugs and typing errors.
Download via the ASAP Utilities FAQ