<p>操作非常简单啊!</p><p><span style="FONT-SIZE: 12pt; FONT-FAMILY: 宋体; mso-ascii-font-family: "Times New Roman"; mso-hansi-font-family: "Times New Roman"; mso-bidi-font-family: "Times New Roman"; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">使用“小管家”必须启用“宏”</span><span style="FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman"; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-fareast-font-family: 宋体;">
</span><span style="FONT-SIZE: 12pt; FONT-FAMILY: 宋体; mso-ascii-font-family: "Times New Roman"; mso-hansi-font-family: "Times New Roman"; mso-bidi-font-family: "Times New Roman"; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">。启用“宏”的方法是:先任意打开一个</span><span lang="EN-US" style="FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman"; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-fareast-font-family: 宋体;">Excel</span><span style="FONT-SIZE: 12pt; FONT-FAMILY: 宋体; mso-ascii-font-family: "Times New Roman"; mso-hansi-font-family: "Times New Roman"; mso-bidi-font-family: "Times New Roman"; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">文件,选择“工具”→“宏”→“安全性”→“中”→“确定”</span><span style="FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman"; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-fareast-font-family: 宋体;">
</span><span style="FONT-SIZE: 12pt; FONT-FAMILY: 宋体; mso-ascii-font-family: "Times New Roman"; mso-hansi-font-family: "Times New Roman"; mso-bidi-font-family: "Times New Roman"; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">,然后关闭这个</span><span lang="EN-US" style="FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman"; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-fareast-font-family: 宋体;">Excel</span><span style="FONT-SIZE: 12pt; FONT-FAMILY: 宋体; mso-ascii-font-family: "Times New Roman"; mso-hansi-font-family: "Times New Roman"; mso-bidi-font-family: "Times New Roman"; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">文件,然后再打开“小管家”</span><span style="FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman"; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-fareast-font-family: 宋体;">
</span><span style="FONT-SIZE: 12pt; FONT-FAMILY: 宋体; mso-ascii-font-family: "Times New Roman"; mso-hansi-font-family: "Times New Roman"; mso-bidi-font-family: "Times New Roman"; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">→选择启用“宏”就可以进行操作了。关闭“小管家”时必须选择保存。</span></p>
凭证的输入是否能数量金额式输入呢?还有,是否可以修改科目的名称或者是减少科目
[此贴子已经被作者于2010-7-14 8:57:01编辑过]
<p>真是好东东啊</p>
<p>回82</p><p>1、“小管家”是可以进行数量金额核算的,双击“借方金额”(L4)或“贷方金额”(M4)单元格,系统就会展开数量金额列,就可以录入数量金额凭证了。必须注意,数量必须用正数输入,系统会根据金额是在借方还是贷方自动确定数量是增还是减。单价不用输入,系统会自动生成。</p><p>2、科目一旦启用后是不能随意修改的,道理很简单,你的科目已经做过凭证了,你又在科目表中将其修改,这样科目就不一致了,当然更不能随意删除。如要对科目进行修改或删除,必须在年度结转后账务处理前进行。</p>
<p>看看学习</p>
<p>多谢分享!</p>
真的是好东西
谢谢分享!试试看
<p><font style="BACKGROUND-COLOR: #cce8cf;">王老师,你好!</font></p><p><font style="BACKGROUND-COLOR: #cce8cf;">为什么我试用时会出现以下情况:</font></p><p><font style="BACKGROUND-COLOR: #cce8cf;">运行时错误'1004'</font></p><p><font style="BACKGROUND-COLOR: #cce8cf;"> 你所提借的密码不正确,请检查CAPS LOCK键的状态,并确认提供了正确的大小写。</font></p>
<p>回89</p><p>这是因为你手工改动了工作表保护密码,注意工作表保护密码是不能手工直接改动的,如要修改必须通过系统提供的方法修改有关权限操作密码,这样有关的工作表密码会自动得到相应修改。</p>
[此贴子已经被作者于2010-7-17 11:15:29编辑过]