Computers & Internet Logo

Related Topics:

Posted on Mar 05, 2008
Answered by a Fixya Expert

Trustworthy Expert Solutions

At Fixya.com, our trusted experts are meticulously vetted and possess extensive experience in their respective fields. Backed by a community of knowledgeable professionals, our platform ensures that the solutions provided are thoroughly researched and validated.

View Our Top Experts

Software problem; Lotus 1-2-3 Release 9 for Windows

Hi,

I have been working on these 2 related issues non-stop for days now.....I really hope you can help me:

I am working in a spreadsheet created with Lotus 1-2-3, Release 9 for Windows. I am using an HP AMD desktop with XP Professional OS.

I have created several radio buttons (placing one button per row within a designated column of the spreadsheet) Each button is hyperlinked to its own specific web addresses. The radio buttons work fine and there is nothing wrong with the links.

PROBLEM: The column is included in the range selected for print, but no matter what I try, the buttons will not print. The range is printed, but the rows are blank;

PROBLEM 2: When I select the radio button and open its drawing properties, the options are shaded (or grayed out) and not abled for selection. Per the user HELP content, I have verified, over verified, and over, over, verified that the workbook cells, sheet cells, range cells, and individual cells are all unlocked and are not protected.

Any suggestions are greatly appreciated. Thanks, Linda

[email protected]

  • 4 more comments 
  • DixieDoodle Mar 05, 2008

    HP 2410 V All in one

  • DixieDoodle Mar 05, 2008

    I would appreciate further help from any assistants who may have expertise with this software. It is not a printer problem. Thank you. DixieDoodle

  • DixieDoodle Mar 05, 2008

    I am not a novice user. I have tried everything I can think of. This answer must come from an experienced Lotus 1-2-3 member. Thank you.

  • DixieDoodle Mar 06, 2008

    Nothing helpful.

  • DixieDoodle Mar 06, 2008

    I'll try one last time to define my problem:

    I have created a huge spreadsheet in Lotus 1-2-3.

    The huge spreadsheet contains one column of buttons which were created using the "create" command.

    Each button links to its own specific website.

    When using the spreadsheet, the buttons are visible, and all buttons work. (Each goes directly to the website it is set-up to go to.)

    NOW........

    I go through the page preview and set-up command.

    Everything is visable and correct on the screen...... EXCEPT the column with the buttons. The column shows up with its background colors (the same as all other columns) but the buttons are not present.

    When I select the button and open its properties, the tab for setting-up the buttons, font, etc. is shaded (grayed out).

    I don't want a wordpad document with buttons.

    I just want to be able to go in and adjust some of the button attributes, and print my spreadsheet - with the buttons visible.


    Thank you

  • DixieDoodle Mar 06, 2008

    Please, are there any experienced Lotus 1-2-3 users available? Thank you. Linda

×

7 Answers

Jose Magnan

Level 2:

An expert who has achieved level 2 by getting 100 points

Hot-Shot:

An expert who has answered 20 questions.

Corporal:

An expert that has over 10 points.

Mayor:

An expert whose answer got voted for 2 times.

  • Expert 57 Answers
  • Posted on Mar 06, 2008
Jose Magnan
Expert
Level 2:

An expert who has achieved level 2 by getting 100 points

Hot-Shot:

An expert who has answered 20 questions.

Corporal:

An expert that has over 10 points.

Mayor:

An expert whose answer got voted for 2 times.

Joined: Feb 11, 2008
Answers
57
Questions
1
Helped
21321
Points
133

Do Alt Print Screen and the paste into wordpad the print it

Anonymous

Level 3:

An expert who has achieved level 3 by getting 1000 points

All-Star:

An expert that got 10 achievements.

MVP:

An expert that got 5 achievements.

Brigadier General:

An expert that has over 10,000 points.

  • Master 6,966 Answers
  • Posted on Mar 07, 2008
Anonymous
Master
Level 3:

An expert who has achieved level 3 by getting 1000 points

All-Star:

An expert that got 10 achievements.

MVP:

An expert that got 5 achievements.

Brigadier General:

An expert that has over 10,000 points.

Joined: Apr 06, 2007
Answers
6966
Questions
17
Helped
3090425
Points
19604

Hi,

If I may add to the other posted solutions:

To my recollection, Lotus 1-2-3 suppresses the printing of a row if the first character is a pipe character/vertical bar (|), the vertical bar probably won't be visible in the worksheet grid; look at the cell address along the top of the window. Pls verify that no pipe character(s) are embedded somewhere in the range you would want printed.

Alternately, to verify whether the cells/range are hidden, highlight all of the cells in question, right-click and select "Range Properties" (from the pop-up menu), click on the "Security tab" (key icon) and verify that there is no check mark in the Hide Cell Contents checkbox.

Hope this be of additional help/idea. Pls post back how things turned up or should you need additional information.

Good luck and kind regards.

Thank you for using FixYa.

  • Anonymous Mar 07, 2008

    Hi again,

    Have you tried printing from "HTML Preview"?

  • Anonymous Mar 08, 2008

    Any development(s) with your Lotus 1-2-3 concern?

×

Ad

Anonymous

Level 3:

An expert who has achieved level 3 by getting 1000 points

All-Star:

An expert that got 10 achievements.

MVP:

An expert that got 5 achievements.

Master:

An expert who has achieved Level 3.

  • Master 555 Answers
  • Posted on Mar 06, 2008
Anonymous
Master
Level 3:

An expert who has achieved level 3 by getting 1000 points

All-Star:

An expert that got 10 achievements.

MVP:

An expert that got 5 achievements.

Master:

An expert who has achieved Level 3.

Joined: Nov 07, 2007
Answers
555
Questions
1
Helped
174578
Points
1438

Would you be willing to send me your file so I can look at it? [email protected]

Anonymous

Level 3:

An expert who has achieved level 3 by getting 1000 points

All-Star:

An expert that got 10 achievements.

MVP:

An expert that got 5 achievements.

Vice President:

An expert whose answer got voted for 100 times.

  • Master 818 Answers
  • Posted on Mar 05, 2008
Anonymous
Master
Level 3:

An expert who has achieved level 3 by getting 1000 points

All-Star:

An expert that got 10 achievements.

MVP:

An expert that got 5 achievements.

Vice President:

An expert whose answer got voted for 100 times.

Joined: Feb 28, 2008
Answers
818
Questions
0
Helped
459632
Points
2161

1) The column and row labels of the currently selected cell are highlighted in ..... If you highlight a range to be printed, this print area is ignored.
2) have you associated the button with a event?
Thanks
Sergio

Anonymous

Level 3:

An expert who has achieved level 3 by getting 1000 points

Superstar:

An expert that got 20 achievements.

All-Star:

An expert that got 10 achievements.

MVP:

An expert that got 5 achievements.

  • Master 983 Answers
  • Posted on Mar 05, 2008
Anonymous
Master
Level 3:

An expert who has achieved level 3 by getting 1000 points

Superstar:

An expert that got 20 achievements.

All-Star:

An expert that got 10 achievements.

MVP:

An expert that got 5 achievements.

Joined: Feb 05, 2008
Answers
983
Questions
8
Helped
434502
Points
2838

If you are doing web designing then i suggest you to use the softwares like front page,coffee cup,hot dog...
this coffee cup,hot dog are very famous softwares used for web designing... you can simply insert some default button and give links without writing scripts the scripts will be loaded by itself it is purely GUI based.. and u can insert your own graphical designed buttons etc..there will be many other options available...
front page is available in ms-office by default.. it depends on which version you have installed...

krishna Singh

Level 3:

An expert who has achieved level 3 by getting 1000 points

All-Star:

An expert that got 10 achievements.

MVP:

An expert that got 5 achievements.

Vice President:

An expert whose answer got voted for 100 times.

  • Master 407 Answers
  • Posted on Mar 05, 2008
krishna Singh
Master
Level 3:

An expert who has achieved level 3 by getting 1000 points

All-Star:

An expert that got 10 achievements.

MVP:

An expert that got 5 achievements.

Vice President:

An expert whose answer got voted for 100 times.

Joined: Jan 19, 2008
Answers
407
Questions
17
Helped
108278
Points
1057

Hi hope you load office 2007 (vista) you try to print excel some data 1st
if your print ok then try to Lotus 1-2-3 Release 9 for Windows update ....
 if you try Lotus 1-2-3 Release 9 for Windows  setup properly .....
To eliminate the Welcome and New Workbook boxes from opening when 1-2-3 launches, choose File, User Setup, and 1-2-3 Preferences. Under the General tab, deselect Show....then print

Damen Wong

Level 3:

An expert who has achieved level 3 by getting 1000 points

All-Star:

An expert that got 10 achievements.

MVP:

An expert that got 5 achievements.

President:

An expert whose answer got voted for 500 times.

  • Master 1,950 Answers
  • Posted on Mar 05, 2008
Damen Wong
Master
Level 3:

An expert who has achieved level 3 by getting 1000 points

All-Star:

An expert that got 10 achievements.

MVP:

An expert that got 5 achievements.

President:

An expert whose answer got voted for 500 times.

Joined: Dec 10, 2007
Answers
1950
Questions
0
Helped
1027665
Points
5739

Hi,

Could you please tell me which printer you are using? Thanks!

Add Your Answer

×

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1helpful
1answer

How to stop 'No Sitemap Found' error in Lotus Notes?

In case you get the error message, while trying to open your mail file using the icon on the workspace, you can dismiss the error message and close all the opened tabs of the mail file. Go to the workspace and use the icon to again open the mail file.
Notes: The 'No sitemap found' error message usually occurs when you open the mail file from the workspace, while mailbox and calendar tabs of a previous session are still open.
There are various other ways to fix such error messages and issues occurring in Lotus Notes. In case you are still not able to see mail items in the mailbox folders, you can use various techniques to recover inaccessible or lost mail items from Lotus Notes.
Since, Lotus Notes is a professional software, used mostly in organizations for an efficient communication; it is advised to use a professional tool to overcome any issue including data loss situations.
Recovery Toolbox for Lotus Notes is a highly efficient tool to recover user mailbox items like emails, contacts, notes, journals, etc. from corrupt or inaccessible Lotus Notes database files. With the ability to display preview of all the recoverable items, the tool ensures an efficient recovery process. The recovered files can be then saved in any desired location. In addition, the tool is widely compatible across various versions of Windows operating system including Windows 8, 7, Vista, Server 2003, XP, 2000, and NT (SP6).
Here the link: https://recoverytoolbox.com/lotusnotes.html
1helpful
2answers

Could someone help me with lotus notes issue?

Hello!
First of all try these steps
1 Open the "Start" menu and click "Computer" or "My Computer" depending on your version of Windows. Navigate to the C drive.
2 Open the "Notes" folder. Double-click on the "Notes.ini" file to open it in Notepad.
3 Place a semicolon (;) in front of the following two lines to temporarily disable VirusScan: AddInsMenus=NCMenu EXTMGR_ADDINS=NCExtMgr
4 Click the "Save" option from the "File" menu. Close Notes.ini. If the steps do not help you try to use Lotus Notes Fix Toolbox https://www.fixtoolbox.com/lotusnotesfix.html
0helpful
1answer

I am trying to get my 4D program to open but it says HASP SRM enviroment (H00330) using my laptop. I have unpluged the computer but it still comes up but I don't have that problem if I use the desk...

Hi Geoff, The H0033 error is a known issue, but it is nothing wrong with your software or the physical dongle !
The issue is related to the Anti-Virus/Firewall software settings in your computer. This is why it can work on one computer and doesn't work on another.
There are unfortunately a lot of different firewall software products available on the market, so it is not easy to give exact steps to correct this for each and every available product. You need to tell your Anti-Virus program to allow the software to open.

Herewith is a way to change the settings on Norton 2008. If your are using a different Anti-Virus and understand the logic behind it, you should be able to change the settings:

Norton Internet Security 2008
1. Open Norton Internet Security 2008
2. Click on the Options link on the bottom left of the screen.
3. Click on Norton Internet Security from the drop-down list.
4. The Norton Internet Security Option screen will open.
5. Click on the Personal Firewall link on the left of the screen.
6. Click on the Program Control link.
7. Select the hasplms entry.
8. Change the Access drop-down list from Custom to Allow.
9. Click Apply then click OK.

0helpful
1answer

Excel is devloped for which operating system

Microsoft Excel has become a crucial tool in the international workplace, providing basic database functionality, along with spreadsheet and calculation tools. While it is currently the market leader for spreadsheets, the history of excel shows that throughout the 1980s and 90s it faced significant competition from rival software platforms like Lotus Notes, Mosaic TWIN and the Paperback VP Planner. The original Microsoft spreadsheet program was called Multiplan - which began development in 1982 - but it was never as financially successful as Lotus Notes.
Interestingly, Excel was first developed for the Macintosh operating system beginning in 1984. It made use of graphical menus and the mouse, innovating strongly relative to the other major competitors at the time. Drop-down menus and a point and click interface helped to make it more usable to non-technical workers, and in turn helped to influence graphical user interfaces in other software and operating systems at the time.
As such, when Windows was launched in 1987, Excel was one of the most important and popular pieces of software for it. The early exploration of the graphical user interface for Windows had already been conducted and market tested by earlier versions of Excel. While it was certainly not the first spreadsheet software package, it was the first to provide a powerful combination of usability and functionality to business clients of all sizes.
Lotus was relatively slow to bring Lotus 123 to Windows, failing to predict the popularity of the operating system.
One of the major turning points in Excel was the inclusion of Visual Basic for Applications in 1993, which greatly increased the functionality of the software. In turn, it also encouraged a generation of professionals to learn the programming language, further solidifying the long term demand for Excel over other spreadsheet suites


Read more: http://www.brighthub.com/office/collaboration/articles/13188.aspx#ixzz1IWkjtDx5
0helpful
1answer

Error code 0xc004f063 Bios Licensing software

http://social.microsoft.com/Forums/en-US/genuinevista/threads

“Issues relating to the Windows Vista Software Protection Platform - Non-Genuine dialog boxes, validation problems, or Software Licensing Services messages.”

If the information/help below does not work, repost your question in the above Forum.

http://www.microsoft.com/windows/windows-vista/quick-start/activation-faq.aspx

Activation FAQs at above link.


1. Click Start, and in the Search box type: slui.exe 4
2. Press ENTER on your Keyboard
3. Select your Country.
4. Take the Phone Activation option, and hold on for a real person.

Cheers.
0helpful
2answers

I have a new computer with Windows 7 and I wanted to install Lotus Freelance Graphics 9.0. It did not work. Is there any possibility to fix this problem. Lotus 1-2-3 9.0 is working properly.

I did not see a driver for Win7 on their website but it is worth contacting them. they may have a driver that they can suggest although I don't even see one for Vista. Here is the link to their web. You have nothing to lose by contacting them. Good Luck and Happy New Years.

http://www.ibm.com/Search/?q=Lotus+Freelance+Graphics+2+windows+7+driver&v=16&en=utf&lang=en&cc=us&Search=Search
0helpful
1answer

Want to load lotus on to a vista system.....can I??

  • The Notes 8.0 feature release (released in August 2007) was fully tested and is supported with Windows Vista.
  • The Notes 7.0.3 maintenance release (released in October 2007) was fully tested and is supported with Windows Vista.
  • Notes 7.0.2, the in-market Notes release (shipped in September 2006) when Vista was released on January 20, 2007, is supported on Windows Vista. Releases prior to Notes 7.0.2 are not supported on Windows Vista.
  • Due to the broad changes in the Windows Vista release, and no more 6.5.x Maintenance Releases, Notes 6.5x is not supported on Windows Vista.
1helpful
1answer

How do you set the time and date? Thanks

Hi!

First of all you need to set the Language which allows you to set the answer in either English or in Spanish voice menu mode. Once the language is set, all voice menu, including the ones used in Remote access mode, will be switched to the selected language.
1. Press and hold the STOP/SET button for two seconds, then release to access the set-up menu.
2. The answering machine announces, "For English, press NEXT, press SET to continue (in English). Para espanol, oprima PREVIO, oprima PROGRAMAR para continuar (in Spanish)".
3. Press NEXT, answerer enters English voice menu mode. If PREVIOUS is pressed, answerer enters Spanish voice menu mode. If SET is pressed, answerer remains in the current language mode. In any case, the answerer enters to the TIME/DAY menu.
NOTE: Language can only be set when the user is in physical access of the unit. When you are running in Remote Access mode, the language cannot be changed and will remain in the language you’ve previously set.10
Setting the Time/Day : This setting allows you to set the current time and day for the Time/Day stamp attached to each message.
Hour : 1. When you have completed setting the Language, the unit will enter the TIME/DAY menu. The answering system announces, "Time (the current time and day setting) To set hour, press next...press set to continue."
2. To change the hour, press and release the NEXT or PREVIOUS button and the answering system announces an hour, such as "12am, 1am, 2am," or "12am, 11pm, 10pm."
3. After choosing the hour, press and release the STOP/SET button to store the hour. The answering system enters the Minute menu.
Minutes : 1. The answering system announces, "(the current minutes setting). To set minutes, press next...press set to continue."
2. To change the minutes, press and release the NEXT or PREVIOUS button, and the answering system announces a minute such as "1, 2, 3" or "59, 58, 57."
3. After choosing the minute, press and release the STOP/SET button to store the minute. The answering system enters the Day menu.
Range of Settings
Time
Hour 12 a.m. - 11 p.m.
Minute 0 - 59
Day Sunday - Monday
Rings 2,3,4,5 toll saverto Answer
Message time 1,2,3,4, minutes
Security 0 - 9, 0 - 9, 0 - 9Code
Default Settings
Time 12 a.m. Sunday
Rings to Answer 4
Message time 2
Security Code 12311
Day
1. The answering system announces, "(the current day setting) To set day, press next...press set to continue."
2. To change the day, press and release the NEXT or PREVIOUS button, and the answering system announces a day, such as "Sunday, Monday" or "Sunday, Saturday."
3. After choosing a day, press and release the STOP/SET button to store the day. The answering system enters the Rings to Answer menu.

Thanks for using FixYa and do rate the solution as Fixya, if found helpful.

Thanks
Rylee
Not finding what you are looking for?

352 views

Ask a Question

Usually answered in minutes!

Top Computers & Internet Experts

Grand Canyon Tech
Grand Canyon Tech

Level 3 Expert

3867 Answers

Brad Brown

Level 3 Expert

19187 Answers

Cindy Wells

Level 3 Expert

6688 Answers

Are you a Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...